Oracle – Is Oracle DBA Privilege include “CREATE ANY TABLE” role


I Just need to create table from a user to any user under the same DB.
letz consider 3 Schemas.

Schema_1,Schema_2 and Schema_3.

schema 1 had DBA Privilege.

Is it possible to table in SChema_2 or Schema_3 from Schema_1????

or we need to give this role "CREATE ANY TABLE" also ??

Best Answer

The DBA role should have this privilege in a typical installation - you can see other roles/users who have this by:

select grantee from dba_sys_privs where privilege = 'CREATE ANY TABLE'