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