Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PDB_DBA has DBA role, but no quota on tablespace

s_kosourOct 30 2014 — edited Oct 30 2014

Hi all,

I have weird situation and I can't find in doco why is that:

I have created PDB with role DBA for admin user, I can see that PDB_DBA role has DBA role. I can  create table in admin user schema, but can't insert rows there, as there are no quota on tablespace. If I grant DBA to admin user directly- I can insert rows - so, I got "quota unlimited" as part of DBA role:

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>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2014
Added on Oct 30 2014
2 comments
3,602 views