Database Administration (MOSC)

MOSC Banner

User A attempting to create table in User B schema - recieve ORA-01031: insufficient privileges

TITLE: User A attempting to create table in User B schema - receive ORA-01031: insufficient privileges error message (12.2 EE DB)

Hello Oracle Team,

Database Version: 12.2 Enterprise Edition

ISSUE: Attempting to have user A create a table in user B schema and I am receiving ORA-01031: insufficient privileges error message.

STEPS TAKEN:

VIA SYS USER granted CREATE ANY TABLE to user A (see chart below for system privileges granted to user A).

Verified through DBA_TS_QUOTAS that user A has unlimited tablespace quota on user B's default tablespace and user A's default tablespace also.

(Note: Verified SYS user was able to create a table in schema B

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