|Oracle Schema : (User account)
Script:SELECT table_name FROM
all_tables WHERE owner ='SCOTT'
| This one took for ever : my purpose was to query one
user or schema like "SCOTT'. , could be accomplished with the above.
Please note that used PHP programming language.
Below includes all the owner accounts.
The same query with default user ( postgre) using pgaAdmin.exe, with enterprise manager where default user "postgres" had access to other objects,
SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name