Database Administration (MOSC)

MOSC Banner

Can a local user in a PDB use a local system privilege on the schema of a common user?

edited Jul 2, 2018 5:16PM in Database Administration (MOSC) 7 commentsAnswered ✓

Hello all,

in Oracle Database 12c (release 12.1.0.2.0) in the multitenant configuration, I've found that a local user having the "CREATE ANY TABLE" local privilege in a PDB  **cannot** create any table in the schema of a common user.

This seems quite weird to me!

The same local user CAN, however, exercise other local system privileges, such as "SELECT ANY TABLE", "DROP ANY TABLE", etc. in the common user's schema.

Is it a bug or a feature?  Or maybe am I missing something?

I would really appreciate your opinion.

Here is my testcase:

/* in CDB$ROOT, create common user */

$ sqlplus / as sysdba

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center