Oracle Basic User Rights

First, the user

When you create a data instance, Oracle creates some default database users, such as Sys,system and Scott. SYS and system users are users of Oracle systems, and Scott users are a test account for the Oracle database, which contains a number of test sample tables.

　1, SYS

SYS user is a super user in Oracle. All data dictionaries and views in the database are stored in the SYS mode. The data dictionary stores all the information that is used to manage database objects and is a very important system information in the Oracle database.

The SYS user unit is primarily used to maintain system information and management examples. SYS users can only log on to the system in Sysoper or SYSDBA roles.

2. SYSTEM

The system user is the default sysadmin in Oracle and has DBA authority. The user has internal tables and attempts that Oracle management tools use. Manage users, permissions, storage, and more in Oracle through system users.

Creating a user table in system mode is not recommended. System cannot be logged in as a ysoper or sysdba role, only in the default mode.

3. SCOTT

The Scott user is a model user of the Oracle database, which is created during the general database installation.

The Scott model includes 4 demonstration tables, EMP (Employee table), DEPT (departmental table), Salgrade (payroll), BONUS (bonus table).

　　

4. All system users and permissions in Oracle

ODM

valign= " Top "width=" ">

User name	Password	Description
Ctxsys	Ctxsys	Ctxsys is a intermedia Text of users, have CONNECT,RESOURCE,DBA Permissions
Dbsnmp	Dbsnmp	Dbsnmp include Connect,resourcehe snmpagent database roles. Run the catnsmp.sql script to remove the role and the user.
INTERNAL	ORACLE	INTERNAL used to perform database administration tasks. Include start, close. Note 1:INTERNAL is not a real user name, it is the SYS user name and an alias for the SYSDBA permission. Note 2: The user needs a password when the Oracle8i database is not installed, otherwise no password is required.
Mdsys	Mdsys	Mdsys is a ORACLE the spatial data ( Spatial ) and Media ( intermedia ), Audio ( Audio ), Video ( Vidio ) and the administrator user name for the image.
Mtssys	Mtssys	Mtssys is in ORACLE of the MTS (Microsoft Transaction server- Microsoft Conversion Server ) the user name under . See Using Microsoft Transaction Server with oracle9i
Lbacsys (oracle9i)	Lbacsys	LBACSYS  Yes oracle identify the security administrator user
ODM (oracle9i)	ODM&NBSP is Data mining user ,ODM performs a data mining operation. See  oracle9i Data Mining Administrator ' s Guide and oracle9i Data Mining Concepts
odm_mtr (oracle9i)	MTRPW	ODM_MTR  is a user of a data Mining sample program see  oracle9i Data Mining Administrator ' s Guide with oracle9i Data Mining Concepts
Olapsys (oracle9i)	MANAGER	olapsys  used to create olap metadata for the user. Includes olap_dba,resource ,  CONNECT  role. oracle9i OLAP User's Guide
Ordplugins	Ordplugins	Ordplugins is a ORACLE intermedia and the Video 's user name. It has CONNECT and RESOURCE roles.
Ordsys	Ordsys	Ordsys is a ORACLE intermedia Audio Video Locator and the Image 's user name. It has CONNECT and RESOURCE roles.
Outln	Outln	outln have CONNECT and the RESOURCE roles and supports program stability. Program stability is a new feature of ORACLE. For optimization.
SYS	Change_on_install	SYS used to perform database administration tasks. It includes the following roles: Aq_administrator_role Aq_user_role, CONNECT Ctxapp, DBA, Delete_catalog_role Execute_catalog_role Exp_full_database Hs_admin_role, Imp_full_database Java_admin, Javadebugpriv Javaidpriv, Javauserpriv Oem_monitor Recovery_catalog_owner RESOURCE, Select_catalog_role Snmpagent, TIMESERIES_DBA Timeseries_developer
SYSTEM	MANAGER	SYS used to perform database administration tasks. It includes the following roles: Aq_administrator_role and the DBA role.
SCOTT	TIGER	SCOTT users include CONNECT and the RESOURCE database roles.

The above is the system default Oracle user and password introduction.

　　5. Custom user

In addition to the system-provided users, Oracle also allows users to create their own users to access and manage databases. Each table has a default tablespace and a temporary table space. If not specified, Oralce sets the users as the default tablespace and sets temp as the temporary tablespace.

(1) Create a user

Grammar:

CREATE USER username

Identified by password

[DEFAULT tablespace tablespace]

[Temporary tablespace tablespace]

In the syntax:

Username: Represents the created user name.

Password: represents the password created.

Default Tablespace tablespace: Specifies the table space, or users if not specified.

Temporary tablespace tablespace: Specifies a temporary tablespace, or temp if not specified

Example:

Create User  by Shop   --Create a user named Shop_user, the password forshopdefault  tablespace shop_dev_data           --Specify the default tablespace as Shop_dev_data
Temporary temp;                 --Specifies that the temporary tablespace is temp;

　　When a new user is added, the user does not have any permissions, and the user needs to be authorized to access the database.

　　To query the default tablespace and temporary tablespace for all users:　

-- Querying user default tablespace, temp table space Select  from Dba_users;

　　

(2) Change password

Grammar:

ALTER USER username

Identified by password

In the syntax:

Username: Indicates the user name to be modified

Password: Represents the new password to be modified

ALTER USER   by "123123"  -- Modify the Shop_user user to 123123, here must use double quotation marks to cause the password

(3) Delete user

Grammar:

DROP USER Shop_user CASCADE

DROP USER Cascade   --delete the Shop_user user, if the user contains data, you must use the Cascade keyword. 

　　

Oracle Basic user Rights