OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » users

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

users [message #250824]

Wed, 11 July 2007 08:11

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
how to differentiate users created by default with a starter database, from user created later on by the administrator
is there a query or something ?
and most applications create schemas right after creating the starter database...the creation date can help ?
by the way whats the difference between schemas and users
thanks

[Updated on: Wed, 11 July 2007 08:13]

Report message to a moderator

Re: users [message #250827 is a reply to message #250824]

Wed, 11 July 2007 08:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select created from v$database;
CREATED
-------------------
08/06/2006 14:45:51

1 row selected.

SQL> select username, created from dba_users order by created;
USERNAME                       CREATED
------------------------------ -------------------
SYS                            08/06/2006 14:46:15
SYSTEM                         08/06/2006 14:46:15
OUTLN                          08/06/2006 14:46:18
DIP                            08/06/2006 14:48:48
TSMSYS                         08/06/2006 14:52:11
DBSNMP                         08/06/2006 14:53:39
WMSYS                          08/06/2006 14:54:35
EXFSYS                         08/06/2006 14:58:55
DMSYS                          08/06/2006 14:59:11
ANONYMOUS                      08/06/2006 14:59:42
MDSYS                          08/06/2006 15:00:32
ORDSYS                         08/06/2006 15:00:32
ORDPLUGINS                     08/06/2006 15:00:32
SI_INFORMTN_SCHEMA             08/06/2006 15:00:32
OLAPSYS                        08/06/2006 15:09:10
SYSMAN                         08/06/2006 15:10:51
MGMT_VIEW                      08/06/2006 15:13:12
MICHEL                         09/06/2006 08:39:30
SCOTT                          20/06/2006 16:02:10
HR                             20/06/2006 16:05:36
OE                             20/06/2006 16:05:47
PM                             20/06/2006 16:07:32
IX                             20/06/2006 16:08:04
SH                             20/06/2006 16:08:16
BI                             20/06/2006 16:11:12
PAT1                           18/10/2006 07:44:58
PAT2                           18/10/2006 07:45:19
XDB                            06/02/2007 14:05:44
TEST                           28/06/2007 09:13:03

32 rows selected.

Regards
Michel

Report message to a moderator