Which of the following statements allows user USER1 to take the ability to create packages in a
database named SAMPLE away from user USER2?
A.
REVOKE CONNECT ON DATABASE FROM user2
B.
REVOKE CREATETAB ON DATABASE FROM user2
C.
REVOKE BIND ON DATABASE FROM user2
D.
REVOKE BINDADD ON DATABASE FROM user2
BINDADD
Grants the authority to create packages. The creator of a package automatically has the CONTROL privilege on that package and retains this privilege even if the BINDADD authority is subsequently revoked.
CONNECT
Grants the authority to access the database.
0
0
BINDADD
Revokes the authority to create packages. The creator of a package automatically has the CONTROL privilege on that package and retains this privilege even if his BINDADD authority is subsequently revoked.
The BINDADD authority cannot be revoked from an authorization-name holding DBADM authority without also revoking the DBADM authority.
0
0