How to install and delete ORACLE default users

There are multiple users in the ORACLE database. The following describes the installation and deletion methods of ORACLE default users for your reference. If you are interested in ORACLE default users, take a look.

When the ORACLE database is created, a series of ORACLE default users and tablespaces are created. Their list is as follows:
· SYS/CHANGE_ON_INSTALL or INTERNAL
System user, data dictionary owner, super permission owner (SYSDBA)
Create Script :? /Rdbms/admin/SQL. bsq and various cat *. SQL
We recommend that you change the password immediately after creation.
This user cannot be deleted
· SYSTEM/MANAGER
The database manages users by default and has DBA role permissions.
Create Script :? /Rdbms/admin/SQL. bsq
We recommend that you change the password immediately after creation.
This user cannot be deleted
· OUTLN/OUTLN
Storage outline users of the optimization plan
Create Script :? /Rdbms/admin/SQL. bsq
We recommend that you change the password immediately after creation.
This user cannot be deleted
---------------------------------------------------
· SCOTT/TIGER, ADAMS/WOOD, JONES/STEEL, CLARK/CLOTH and blke/PAPER.
Lab and test users, including the example Table EMP and DEPT
Create Script :? /Rdbms/admin/utlsampl. SQL
You can change the password.
Users can be deleted. We recommend that you delete or lock a user in the product environment.
· HR/HR (Human Resources), OE/OE (Order Entry), SH/SH (Sales History ).
Lab and test users, including the example Table EMPLOYEES and Parameters
Create Script :? /Demo/schema/mksample. SQL
You can change the password.
Users can be deleted. We recommend that you delete or lock a user in the product environment.
· DBSNMP/DBSNMP
Oracle Intelligent agent
Create Script :? /Rdbms/admin/catsnmp. SQL, called from catalog. SQL
You can change the password. You need to place a new password in the snmp_rw.ora file.
If you do not need Intelligent Agents, you can delete it.
---------------------------------------------------
The following users are optional installation users. If you do not need to install
· CTXSYS/CTXSYS
Oracle interMedia (ConText Cartridge) Management User
Create Script :? /Ctx/admin/dr0csys. SQL
· TRACESVR/TRACE
Oracle Trace server
Create Script :? /Rdbms/admin/otrcsvr. SQL
· ORDPLUGINS/ORDPLUGINS
Object Relational Data (ORD) User used by Time Series, etc.
Create Script :? /Ord/admin/ordinst. SQL
· ORDSYS/ORDSYS
Object Relational Data (ORD) User used by Time Series, etc
Create Script :? /Ord/admin/ordinst. SQL
· DSSYS/DSSYS
Oracle Dynamic Services and Syndication Server
Create Script :? /Ds/SQL/dssys_init. SQL
· MDSYS/MDSYS
Oracle Spatial administrator user
Create Script :? /Ord/admin/ordinst. SQL
· AURORA $ ORB $ UNAUTHENTICATED/INVALID
Used for users who do not authenticate in Aurora/ORB
Create Script :? /Javavm/install/init_orb. SQL called from? /Javavm/install/initjvm. SQL
· PERFSTAT/PERFSTAT
Oracle Statistics Package (STATSPACK) that supersedes UTLBSTAT/UTLESTAT
Create Script :? /Rdbms/admin/statscre. SQL
 

Default ORACLE user and password

Implementation of oracle multi-column subquery

Oracle multi-Table query instance

ORACLE Database Encoding

Oracle date formatting implementation