Oracle Users

[UAEKing]

Hi all,

Can I know the default Oracle users? Is there any script searchs for them? The other question, what are the differences between sys/system users??? waiting your replay..Thanks in advance!!

[shandj]

You can find the info by querying DBA_USERS table. It gives all the user names currently created in the database.

Default users that are created by Oracle will vary.
SYS
SYSTEM
SCOTT
BLAKE
ADAMS
OUTLN
DBSNMP
CLARK
JONES
OMWB_EMULATION

[agasimani]

Depending on the options you have installed, default users varies, but you might find these users:
SYS, SYSTEM, OUTLN, DBSNMP, MTSSYS, AURORA$ORB$UNAUTHENTICATED, SCOTT
DEMO, ORDSYS, ORDPLUGINS, MDSYS, CTXSYS

SYS is the Oracle dictionary owner, whereas SYSTEM is a user who has been granted all DBA roles and has access to entire dictionary. In other words you can say SYS is the owner of the company and SYSTEM is the manager who has access to all company's funds (and who can screw the company's financial status if he wants)