Which three are true about system and object privileges? (Choose three.)
Which three are true about system and object privileges? (Choose three.)
WITH GRANT OPTION can be used when granting an object privilege to both users and roles, making option B true. Revoking an object privilege granted with WITH GRANT OPTION does have a cascading effect, so option C is also true. Adding a foreign key constraint that points to a table in another schema requires the REFERENCES object privilege, which makes option D correct. Option A is incorrect because WITH GRANT OPTION can be specified when granting object privileges to users and roles, but not to PUBLIC. Option E is incorrect because revoking a system privilege granted with WITH ADMIN OPTION does not have a cascading effect.
But A is also not correct "You can specify WITH GRANT OPTION only when granting to a user or to PUBLIC, not when granting to a role. "
CCD second C alter any table privs
ACD for me E is not correct http://www.dba-oracle.com/t_with_grant_admin_privileges.htm