Materialized Views missing from all_objects
Hi.
Please see below example:
Connect as sys:
SQL> create user test1 identified by "Pass-1234";
SQL> create user test2 identified by "Pass-1234";
SQL> grant connect to test1, test2;
SQL> grant create table, create materialized view to test1;
SQL> alter user test1 quota unlimited on users;
SQL> conn test1
Enter password:
SQL> CREATE MATERIALIZED VIEW MV_ALL_OBJECTS AS
select owner, object_name, object_type
from all_objects;
SQL> grant select on mv_all_objects to test2;
SQL> select mview_name from all_mviews;
MVIEW_NAME
—————————————————-
MV_ALL_OBJECTS
SQL> select object_name from all_objects where object_type='MATERIALIZED VIEW';