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 the role of local roles in relation to local users?

How do local users behave in a multi-tenant environment?

What are the implications of granting local privileges to common users?

What dictionary views can be used to obtain information about users and roles?