Which four statements about users in Oracle Database 12c are correct?

Question

Options

• AA common user cannot have the same name as any local user across all PDBs.
• BA common user can be created only in the root container.
• CA local user with the proper privileges can also create a common user.
• DIf a PDB is closed, the common and local users of the PDB are not visible.
• EA common user with the proper privileges can create a common user by using the
• FA common user is one that has the same username and authentication credentials across multiple

• A
  81% (39)
• C
  13% (6)
• E
  6% (3)

Explanation

https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG99777 About Common Users In a multitenant environment, a common user is a database user whose identity and password are known in the root and in every existing and future pluggable database (PDB). Common users can connect to the root and perform operations. If the common user has the appropriate privileges, then this user can perform operations in PDBs as well, such as granting privileges to A common user can perform administrative tasks specific to the root or PDBs, such as plugging and unplugging PDBs, changing their state, or specifying the temporary tablespace for the multitenant container database (CDB). Only common users who have the appropriate privileges can navigate between containers that belong to a CDB. For example, common users can perform the following operations across multiple PDBs: - Granting privileges to common users or common roles - Running an ALTER DATABASE statement that specifies the recovery clauses that apply to the - Running an ALTER PLUGGABLE DATABASE statement to change the state of a given PDB while connected to the root. A local user connected to a PDB can also change its state, given appropriate privileges. All Oracle-supplied administrative user accounts, such as SYS and SYSTEM, are common users and can navigate across the CDB. Common users can have different privileges in different PDBs. About Local Users In a multitenant environment, local user is a database user that exists only in a single PDB. Local users can have administrative privileges, but these privileges apply only in the PDB in which the local user account was created. Local user accounts have the following characteristics, which distinguish them from common user - Local user accounts cannot create common user accounts or commonly grant them privileges. A common user with the appropriate privileges can create and modify common or local user accounts and grant and revoke privileges, commonly or locally. A local user can create and modify local user accounts or locally grant privileges to common or local users in a given PDB. - You can grant local user accounts common roles. However, the privileges associated with the common role only apply to the local user's PDB. - The local user account must be unique only within its PDB. - With the appropriate privileges, a local user can access objects in a common user's schema. For example, a local user can access a table within the schema of a common user if the common user has granted the local user privileges to access it. - You can editions-enable a local user account but not a common user account.

No community discussion yet for this question.