Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users c# #A admin and B_ADMIN have only connect privileges.
You create a common role c##_role1 with common privileges create table and select any table.
You then execute these commands to grant the role to users In the root container:
SQL> GRANT c##_role1 TO c##_a_admin CONTAINER=ALL;
Then,
SQL> CONN sys/oraclHR_PDB as sysdba
SQL> GRANT C# #_role1 TO b_admin CONTAINER=CURRENT;
Which two statements are true?
Currently there are no comments in this discussion, be the first to comment!