This is driving me batty–what’s the SQL statement to view all the columns AND tables which a user has access to? I know that for just tables, it’s “select * from user tab”. I tried doing a “desc *” in the hope that would work, but it doesn’t. HELP!
I believe it is: SELECT * from user_tab_columns. Order by table name also if you wish.
To see all of the columns, use the view USER_TAB_COLUMNS. By joining USER_TABLES to USER_TAB_COLUMNS (by table_name), you can get all the information needed to generate a report that describes all of the tables that the current user can access.