Home » RDBMS Server » Server Administration » users
users [message #250824] Wed, 11 July 2007 08:11 Go to next message
maoro
Messages: 310
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: users [message #250828 is a reply to message #250824] Wed, 11 July 2007 08:18 Go to previous messageGo to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
waw
thx for immediate help
but my query didnt display the time
just the date
plz help
thanks again
Re: users [message #250835 is a reply to message #250828] Wed, 11 July 2007 08:42 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Then use the TO_CHAR function with a date format or set your NLS_DATE_FORMAT.
Previous Topic: find out top sql
Next Topic: Process associated with Database
Goto Forum:
  


Current Time: Fri Dec 09 13:44:08 CST 2016

Total time taken to generate the page: 0.16007 seconds