In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the…

Question

Options

• AIt executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN
• BIt fails and reports an error because the CONTAINER=ALL clause is not used.
• CIt excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN
• DIt fails and reports an error because the CONTAINER=CURRENT clause is not used.
• EIt executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN

• A
  81% (21)
• B
  12% (3)
• C
  4% (1)
• D
  4% (1)

Explanation

If the current container is the root: /Specify CONTAINER = CURRENT to revoke a locally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root. This clause does not revoke privileges granted with CONTAINER = ALL. /Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege or role granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also If you omit this clause, then CONTAINER = CURRENT is the default.

No community discussion yet for this question.