A Local PDB User with DBA Role Can't Create Table In System Schema And Failed With ORA-01031: insufficient privileges

(Doc ID 2315914.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

1. At 12.1.0.2 multitenant environment, a local PDB user with DBA role create a table in SYSTEM schema failed with ORA-1031:

SQL> show user;
USER is "DBADMIN"

SQL> select granted_role from dba_role_privs where grantee='DBADMIN';

GRANTED_ROLE
--------------------------------------------------------------------------------
PDB_DBA
DBA <<<<<<<<<<<<

SQL> create table system.t1 (id number);

create table system.t1 (id number)
*
ERROR at line 1:
ORA-01031: insufficient privileges

 

2. DBA role has "create any table" system privilege:

SQL> select * from dba_sys_privs where grantee='DBA' and privilege like 'CREATE ANY TABLE%';

GRANTEE PRIVILEGE ADM COM
---------------------------------------- ---------------------------------------- --- ---
DBA CREATE ANY TABLE NO YES

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms