Which of the following statements allows BOB to revoke access to the SAMPLE database from
user TOM?
A.
REVOKE ACCESS ON DATABASE FROM USER bob
B.
REVOKE CONNECT ON DATABASE FROM USER tom
C.
REVOKE tom FROM ACCESS ON DATABASE BY USER bob
D.
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
GRANT (Database Authorities)
CONNECT: Grants the authority to access the database.
0
0
CONNECT
Revokes the authority to access the database.
Revoking the CONNECT authority from a user does not affect any privileges that were granted to that user on objects in the database. If the user is subsequently granted the CONNECT authority again, all previously held privileges are still valid (assuming they were not explicitly revoked).
The CONNECT authority cannot be revoked from an authorization-name holding DBADM authority without also revoking the DBADM authority (SQLSTATE 42504).
0
0