-
Oracle Users
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
________________
ShanDJ
-
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)
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|