Re: List of Oracle delivered database usernames?
- From: "Yong Huang" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "yong321@xxxxxxxxx" for DMARC)
- To: "christopherdtaylor1994@xxxxxxxxx" <christopherdtaylor1994@xxxxxxxxx>
- Date: Fri, 20 Mar 2015 14:22:47 +0000 (UTC)
Resend to include Oracle-L
> This is something I wish Oracle would improve upon.
In 12c, dba_users has a new column oracle_maintained:
SQL> col username for a30
SQL> select username, created, oracle_maintained from dba_users order by 2;
USERNAME CREATED O
------------------------------ --------- -
SYSTEM 28-JUN-13 Y
AUDSYS 28-JUN-13 Y
SYS 28-JUN-13 Y... DVSYS
28-JUN-13 Y
DVF 28-JUN-13 Y
C##YONG 10-JUL-13 N
So that's an improvement. Before 12c, just sort on created, and you know
exactly where the Oracle delivered users stopped. But that only works if you
never add more options to the database after you created it and created some of
your own users in it.
By the way, the 12c new column last_login is also quite useful.
Yong Huang
Other related posts:
