Database Administration (MOSC)

MOSC Banner

Materialized Views missing from all_objects

edited Nov 11, 2024 9:37AM in Database Administration (MOSC) 5 commentsAnswered ✓

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';

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