User Tools

Site Tools


info:oracle:accounts_with_objects

Oracle: List Accounts with Objects

To list all accounts (users) the objects (like tables), you can query them with:

SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER;

If you want to list all accounts, you can query them with:

SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME;

Or, if you only want the DBAs:

SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME;
info/oracle/accounts_with_objects.txt · Last modified: 2013-03-01 21:26 by andunix