Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle Query to get table list for which the current user has read access

Tags:

oracle

How do I query an Oracle database to list the tables where the current user has read privilege?

like image 628
Manikandan Avatar asked Sep 07 '12 07:09

Manikandan


1 Answers

user_tables is users's tables. For all tables that user can read:

select * from all_tables;
like image 194
Florin stands with Ukraine Avatar answered Oct 10 '22 00:10

Florin stands with Ukraine