Which of the following only grant access to update salary on Staff table to HR_Personnel? Choice 1 of 4:GRANT ALL PRIVIL

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Which of the following only grant access to update salary on Staff table to HR_Personnel? Choice 1 of 4:GRANT ALL PRIVIL

Post by answerhappygod »

Which of the following only grant access to update salary on
Staff table to HR_Personnel?
Choice 1 of 4:GRANT ALL PRIVILEGES ON Staff TO HR_Personnel;
Choice 2 of 4:GRANT SELECT, UPDATE(Staff) ON Staff TO
HR_Personnel;
Choice 3 of 4:GRANT UPDATE(salary) ON Staff TO HR_Personnel;
Choice 4 of 4:GRANT UPDATE ON Staff.salary TO HR_Personnel;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply