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

The video tutorial covers managing system privileges and user roles in a database environment. It explains how to grant privileges to common and local users, manage container data attributes, and control data visibility. The tutorial demonstrates creating common users, setting data attributes, and restricting data visibility to specific containers. It concludes with a cleanup of the practice session, summarizing the roles and privileges examined.

What is the scope of the privilege 'create table' granted to C##user1?

• Only in PDB1

• In all containers

• Only in PDB2

• Only in the root container

Which privilege is granted locally to L_user2?

• Create table

• Unlimited tablespace

• Create synonym

• Create sequence

How does the default behavior of the database affect common users querying container data views?

• They see rows from the root container only

• They cannot query container data views

• They see all rows regardless of attributes

• They see only rows allowed by container data user attributes

What is the purpose of setting container data attributes for common users?

• To control what information they can view in container data objects

• To grant them additional privileges

• To allow them to create new users

• To restrict their access to the root container

What happens when C##user2 changes the current container to PDB1?

• They can only see data files of PDB1

• They can see data files of all containers

• They cannot see any data files

• They can see data files of the root container

What is the effect of removing container data attributes for C##user2?

• They can see data files of the root and PDB1

• They can see all data files in all containers

• They can only see data files of the current container

• They cannot see any data files

How can the visibility of container data objects be restricted for C##user2?

• By disabling all container data attributes

• By setting container data attributes for specific PDBs

• By granting additional privileges

• By changing the root container