Which three statements about common and local roles are true?

The correct answer is A. When a role is granted to a user, the privileges in the role are limited to the context of the PDB. C. Common roles can be granted to both local and common users. D. A user can create common roles if the user has the CREATE ROLE privilege, and SET. https://docs.oracle.com/database/121/DBSEG/authorization.htm#DBSEG834 Grants to or Revokes from Common Roles and Local Roles Common users can grant and revoke common roles to and from other common users. A local user can grant a common role to any user in a PDB, including…

Multitenant Architecture

Question

Options

AWhen a role is granted to a user, the privileges in the role are limited to the context of the PDB.
BLocal roles can be granted only to local users.
CCommon roles can be granted to both local and common users.
DA user can create common roles if the user has the CREATE ROLE privilege, and SET
ECommon roles can be created in the root and PDBs.

How the community answered

(27 responses)

A
81% (22)
B
11% (3)
E
7% (2)

Explanation

https://docs.oracle.com/database/121/DBSEG/authorization.htm#DBSEG834 Grants to or Revokes from Common Roles and Local Roles Common users can grant and revoke common roles to and from other common users. A local user can grant a common role to any user in a PDB, including common users, but this grant applies only within the PDB.

Topics

#common roles#local roles#CDB#PDB security

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice