Examine the following steps:
A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY.
SIDNEY grants the CREATE TABLE system privilege to the HR user.
Which statement is true?
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.
Explanation:
http://www.dba-oracle.com/t_with_grant_admin_privileges.htm
The answer should be D. The link provide in the explanation explained that system privileges will not cascade when granted WITH ADMIN OPTION.