Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get list of accessible tables in schema

458704Oct 6 2005 — edited Oct 6 2005
I need get list of table which i have select rights.

1. I try it throught select clausule from tables all_tab_privs and all_tables but it is possible that user has no access to this table. How can i get tables of accessible tables to actual logged user with using this system tables?

2. I try it with full access to oracle system, but i had a lot of problems.
E.g. : I created new table 'TEST'.
When:

SELECT * FROM all_tab_privs where table_name='TEST';

No results.

I don't understand. I thought that i should get row with owner etc. Maybe i make or think something wrong. Can somebody help me?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2005
Added on Oct 6 2005
2 comments
1,732 views