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!!;)
Printable View
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!!;)
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
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)