You can get a list of accessible tables and columns, based on the read ACLs for the
The following query will return the names of all tables that the querying user has read
select * from oa_tables;
After you know the name of the table you want to query, you can query the names of all
columns that the user has read access for. The querying user must have read access for both
the table and the columns.
select * from oa_columns where table_name=‘table_name’;
Note: The oa_tables and oa_columns tables are internal ODBC tables. These tables are
accessible only via the ODBC Driver.