Database Administration (MOSC)

MOSC Banner

user access

edited May 31, 2012 11:01AM in Database Administration (MOSC) 7 comments
Hi:
A a specific user who's been granted select privs on a table, I can login as that user:
> select count(*) from rptadm.CAND_PROFILE_BUS_KEY_PERF_IND;

  COUNT(*)
----------
       243

works great.

Should I not be able to look at the table structure through user_tables?   I am trying but it doesn't work.  What privs would I have to give to the user to be able to do this?

thanks
Ed

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