Fulltext results:

Oracle: List Accounts with Objects

3 Hits, Last modified: 12 years ago

sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; </code> If you want to list all accounts,... <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}}