Database Administration (MOSC)

MOSC Banner

What I cannot view the data even when I have select_catalog_role

edited Jul 6, 2019 5:00AM in Database Administration (MOSC) 7 commentsAnswered

I am connecting to Oracle 12c R2 database instance. My account has select_catalog_role privilege. I can view schema definitions of any schema in the database,

but when I try to look at data, it gives me error. that table/view does not exist. why. .e.h,

select count(*) from testchema.table1

ORA-00942 table or view does not exsit.

But when I do

select count(*) from dba_users

I get a count.

What privileges are needed to view the data. I do not wnat the ability to update data, just view data. Why I can voew data from dba_suers but not for a user schema..

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