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