Which of the following only grant access to update salary on Staff table to HR_Personnel? Choice 1 of 4:GRANT ALL PRIVIL
Posted: Fri May 20, 2022 10:28 am
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;
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;