Multiple choice technology databases

Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

  1. REVOKE CONNECT ON DATABASE FROM user2

  2. REVOKE CREATETAB ON DATABASE FROM user2

  3. REVOKE BIND ON DATABASE FROM user2

  4. REVOKE BINDADD ON DATABASE FROM user2
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

BINDADD is the database-level privilege that allows users to create packages within a database. REVOKE BINDADD ON DATABASE FROM user2 would remove USER2's ability to create packages. CONNECT allows database connection, CREATETAB allows creating tables, and BIND allows binding packages but not creating them.

Keep practicing — related questions