Multiple choice technology mainframe

A user with the SYSADM authority issue the following statement : GRANT ALL PRIVILEGES ON TABLE payroll.employee TO user1 WITH GRANT OPTION Which of the following statement is USER1 authorized to execute?

  1. GRANT CONROL ON TABLE payroll.employee TO user2

  2. GRANT UPDATE ON TABLE payroll.employee TO user2

  3. GRANT CREATE_EXTERNAL_ROUTINE ON TABLE payroll.employee TO user2

  4. GRANT LOAD ON TABLE payroll.employee TO user2
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When SYSADM grants ALL PRIVILEGES WITH GRANT OPTION, USER1 receives all table privileges plus the ability to grant those privileges to others. However, USER1 can only grant privileges they actually possess - CONTROL and CREATE_EXTERNAL_ROUTINE are higher-level privileges not granted by ALL PRIVILEGES on a table.

Keep practicing — related questions