Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I can view data in the table_privileges view logged in as a particular user, but it seems to be missing or different information when logged in as a different user.

For the privileges views (data created when calling GRANT), will users see the data differently in these views? I seem to recall reading that this was the case, but can't confirm now.

Any specific links would be greatly appreciated.

share|improve this question

1 Answer

up vote 3 down vote accepted

The table_privileges view is only preserved for compatibility with ancient versions of Oracle.

You should instead be using the user_tab_privs view, all_tab_privs view, or dba_tab_privs view (documentation links for each when you click).

share|improve this answer
Reading the documentation, the answer seems to be "yes". But thanks for the links, they are indeed helpful. – Spencer K Feb 28 at 19:07
1  
The documentation links were the best way of answering the question. No point in me cutting and pasting :) Your other question on this site actually has an answer that applies to many data dictionary views. ALL_% views show you things you've permission to use/see, USER_% views show you things you own (ish) and DBA_% views show you everything. – Phil Feb 28 at 20:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.