SQL Language (MOSC)

MOSC Banner

Insufficient privileges creating Materialized view in a different schema in oracle 19x

login as user PLOTZD

Attempt to create a Materialized view in SYSADM schema (it works to create this in the plotzd schema).

create materialized view "SYSADM".sscott 

BUILD IMMEDIATE

REFRESH FORCE

ON DEMAND

as select * from dual

Error report -

ORA-01031: insufficient privileges

01031. 00000 - "insufficient privileges"

*Cause:  An attempt was made to perform a database operation without

      the necessary privileges.

*Action:  Ask your database administrator or designated security

      administrator to grant you the necessary privileges


USER plotzd has following privs (granted directly...not through a role)..also has connect

DROP ANY TABLE

ALTER ANY TABLE

CREATE ANY TABLE

CREATE PROCEDURE

DELETE ANY TABLE

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