Column names of a query from a table from another user

It sounds pretty easy to get column names from a table, right? Actually there is an answer to this question How to get column names from a table in Oracle?

The main problem is that the table belongs to another user. My user is for integration only and I do not have any database privileges.

Therefore, I can execute some kind of query: SELECT * FROM anotherUser.THE_TABLE;

But something like SELECT * FROM USER_TAB_COLUMNS does not return rows.

Perhaps I can create queries on all_tab_columns, are there even faster parameters without procedures?

* This is an oracle database!

+6
source share
1 answer
 SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER='ANOTHERUSER' AND TABLE_NAME='THE_TABLE'; 

If you have privileges in the table, you must get there.

+6
source

Source: https://habr.com/ru/post/917551/