Multiple choice technology databases

Which of the following system privileges can allow the grantee to masquerade as another user and therefore should be granted judiciously?

  1. CREATE ANY JOB

  2. ALTER USER

  3. CREATE ANY PROCEDURE

  4. All of the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Privileges like CREATE ANY JOB, ALTER USER, and CREATE ANY PROCEDURE allow a user to execute code as others or modify other accounts. For example, ALTER USER can change a password, and CREATE ANY PROCEDURE can be used to capture higher privileges.