Can a local user in a PDB use a local system privilege on the schema of a common user?
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