Re: List of Oracle delivered database usernames?

in 12c you have
SELECT * FROM DBA_USERS WHERE oracle_maintained ='Y'

If your users don't have objects, then you can say

SELECT * FROM DBA_USERS WHERE not exists(select 1 from dba_objects where owner=username and rownum=1)

2015-03-18 10:36 GMT-04:00 Chris Taylor <christopherdtaylor1994_at_gmail.com>:

> I'm trying to find a master list to use as a filter for some reports of
> ALL Oracle delivered usernames that could be installed in the database when
> you first create a db.
>
> I'm familiar with many of them but I'm hoping to find a complete list -
> like if you installed every possible product, sample schema etc, what would
> that list of usernames be?
>
> Anyone know of a master list anywhere of potential Oracle supplied
> usernames/schemas?
>
> Thanks,
> Chris
>
>

--
http://www.freelists.org/webpage/oracle-l