Oracle Database Administration from Zero to Hero - Managing Local and Common Users

This lecture covers the differences between local and common users in a multi-tenant environment. It explains how to create these users and roles, and how to grant privileges both locally and commonly. The lecture emphasizes best practices, such as dedicating common users for administrators and local users for application schemas. It also highlights the importance of maintaining the common user prefix and avoiding granting local privileges to common users. The lecture concludes with a summary of key concepts and practices for managing users and roles effectively.

What is a key characteristic of a local user in a multi-tenant architecture?

• They are defined at the PDB level.

• They can be created in any container.

• They are known across all PDBs.

• They must start with a specific prefix.

Where must common users be created in a multi-tenant architecture?

• In a specific PDB.

• In any PDB.

• In the root container.

• In a non-CDB database.

What is the default prefix for common usernames?

• P##

• U##

• L##

• C##

What must be done to grant a privilege to a local user?

• Change the current container to the PDB.

• Use the container clause set to all.

• Grant the privilege in a non-CDB database.

• Connect to the root container.

What is a common grant?

• A grant that does not require a container clause.

• A grant that applies only to the current container.

• A grant given to a common user with container set to all.

• A grant given to a local user.

What is the best practice for granting privileges to common users?

• Avoid using any grants.

• Grant privileges in a non-CDB database.

• Use common grants only.

• Grant local privileges directly.

Where are common roles defined?

• In a specific PDB.

• In the root container.

• In a non-CDB database.

• In any PDB.

What is the recommended practice for managing roles?

• Create roles in a non-CDB database.

• Grant local roles to common users.

• Use common roles for common users.

• Avoid using roles altogether.

What should be maintained to avoid conflicts when moving PDBs?

• The default value of the local user prefix.

• The default value of the grant prefix.

• The default value of the common user prefix.

• The default value of the role prefix.

What is the purpose of the OS AUTHENT prefix?

• To create common users in any PDB.

• To allow OS users to access Oracle databases.

• To allow Oracle users to access OS databases.

• To create local users in the root container.