Oracle Database 12c: Installation and Administration — Question 56

Examine the following steps:
A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. grants the CREATE TABLE system privilege to the HR user.

SIDNEY -
Which statement is true?

Answer options

• A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.
• B. HR can grant the CREATE TABLE system privilege to other users.
• C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.
• D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

Correct answer: C

Explanation

The correct answer is C because if the DBA revokes the CREATE TABLE privilege from SIDNEY, it will also affect HR since HR's privilege was derived from SIDNEY's grant. Options A and B are incorrect as they misinterpret the implications of privilege grants and revocations, while option D is incorrect because HR loses its privilege if SIDNEY's is revoked.