SQL> conn / as sysdba Connected. SQL> create pluggable database P1 admin user a identified by a roles=(dba); Pluggable database created. SQL> alter session set container=P1; Session altered. SQL> alter pluggable database P1 open; Pluggable database altered. SQL> create table a.t(id integer); Table created. SQL> insert into a.t values(1); insert into a.t values(1) * ERROR at line 1: ORA-01950: no privileges on tablespace 'SYSTEM' SQL> select * from dba_role_privs where grantee = 'A'; GRANTEE -------------------------------------------------------------------------------------------------------------------------------- GRANTED_ROLE ADM DEL DEF COM -------------------------------------------------------------------------------------------------------------------------------- --- --- --- --- A PDB_DBA YES NO YES NO SQL> select granted_role from dba_role_privs where grantee = 'PDB_DBA'; GRANTED_ROLE -------------------------------------------------------------------------------------------------------------------------------- DBA SQL> SQL> grant dba to a; Grant succeeded. SQL> insert into a.t values(1); 1 row created. SQL> revoke dba from a; Revoke succeeded. SQL> insert into a.t values(1); 1 row created. SQL> |