Oracle Database Administration from Zero to Hero - Practice - Managing Local and Common Users (Part 1 of 2)

This video tutorial covers the management of common and local users and roles in CDB and PTPS. It explains how to create and manage common users, local users, and roles, and how to grant privileges. The tutorial also demonstrates the connection attempts and errors encountered when managing users and roles in different containers.

What is the primary limitation when creating a local user in the root container?

• Local users can be created in any container.

• Local users can only be created by SYSDBA.

• Local users can only be created in PDBs.

• Local users require special privileges.

Why did the connection attempt fail when using a common user with a locally granted privilege?

• The user was not created properly.

• The privilege was not granted correctly.

• The privilege is only effective in the local container.

• The user does not exist in the PDB.

What happens when you try to create a common user in a PDB?

• The user is created successfully.

• An error occurs because common users can only be created in the root.

• The user is created but with limited privileges.

• The user is created as a local user instead.

What is a key characteristic of a common role in a database?

• It cannot be revoked once granted.

• It is automatically assigned to all users.

• It can be assigned to users in all containers.

• It can only be used in the root container.

Why can't local roles be created in the root container?

• Local roles require SYSDBA privileges.

• Local roles are only applicable within PDBs.

• Local roles are automatically created in PDBs.

• The root container does not support role creation.

What is the effect of revoking a common role from a user?

• The user retains the role in PDBs.

• The user loses access to all containers.

• The role is only revoked in the root container.

• The role cannot be used by the user in any container.

What happens when a local grant is revoked from a user?

• The user loses the role in the specific PDB.

• The user retains the common grant.

• The user can still use the role in other PDBs.

• The user loses all privileges in the root container.

How can you verify the active roles for a user in a PDB?

• By listing the active roles in the current session.

• By querying the DBA_USERS view.

• By checking the user’s profile settings.

• By reviewing the user’s privilege history.

What is the result of granting a common role to a local user?

• The role cannot be granted to a local user.

• The role is active only in the specific PDB.

• The role is active in all containers.

• The role is only active in the root container.

What is the significance of verifying role assignments in a database?

• To revoke unnecessary roles from the database.

• To automatically assign roles to new users.

• To create new roles based on user activity.

• To ensure users have the correct privileges.