====== Oracle: List Accounts with Objects ======

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

<code sql>
SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER;
</code>

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

<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}}