Re: List of Oracle delivered database usernames?
- From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- To: christopherdtaylor1994@xxxxxxxxx
- Date: Mon, 23 Mar 2015 17:04:04 -0400
Hello Chris,
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@xxxxxxxxx>:
> 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
>
>
Other related posts:
