Just a quick question

[mooks]

Hi,

I have created grant access to certain tables to userA. If userA login to ORacle, what sql can userA use to query and see what table can userA access to??

Thanks!

[jacoch]

Hi,

Nice simple query

Select table_name from user_tables;

Bye

[jacoch]

Oops,

Nice simple query should be

select table_name from all_tables;

This shows what you can access.

user_tables shows your schema tables.

Bye