Oracle Admin user (i) Oracle build user

1. Concept

(1) User: User (account) is a name defined in the database.

(2) Privileged User: A privileged user is a database user with special permissions (SYSDBA or Sysoper).

SYSDBA automatically has all the privileges of the DBA role, while Sysoper does not have the DBA role's privileges.

(3) Scenario (Schema): A scenario is a collection of database objects owned by a user.

2, the user authentication method

(1) OS authentication: refers to the use of the OS to check the user, password and user identity methods.

(2) Database certification

3, the establishment of user

(1) The user who establishes the database authentication

Sql> Create user Rose

2 identified by Oracle

3 Default tablespace users

4 Temporary Tablespace Temp

5 Quota 10m on users

6 password expire; --User Login password expires, need to reset

User created.

Sql> Grant create session to Rose;

Grant succeeded.

Sql> Conn Rose/oracle

ERROR:

ora-28001:the Password has expired

Changing password for Rose

New Password:

Retype new Password:

Password changed

Connected.

(2) Establish the OS Authentication (operating system authentication) User (sys user belongs to OS authentication)

Sql> Show Parameter Auth

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Os_authent_prefix string ops$--The user name to create an OS authentication must precede this parameter

Remote_os_authent Boolean FALSE

1 Create user ops$oracle--creating users without double quotes

2 identified externally

3 Profile Default

4 Default Tablespace users

5 Temporary Tablespace Temp

6* Quota 10m on users

Sql>/

User created.

Sql> select Username,account_status from Dba_users;

USERNAME Account_status

--------------- -------------------------

Outln OPEN

SYS OPEN

SYSTEM OPEN

ROSE OPEN

SCOTT OPEN

Ops$oracle OPEN

TOM OPEN

Dbsnmp Expired & LOCKED

Tsmsys Expired & LOCKED

DIP Expired & LOCKED

Ten rows selected.

Sql> Select username, password, profile,default_tablespace,temporary_tablespace from Dba_users;

USERNAME PASSWORD profile Default_tablesp temporary_table

--------------- -------------------- --------------- --------------- ---------------

Outln 4a3ba55e08595c81 DEFAULT SYSTEM TEMP

SYS 8a8f025737a9097a DEFAULT SYSTEM TEMP

System 2D594E86F93B17A1 DEFAULT System TEMP

ROSE 1166A1F535AF6EFB DEFAULT USERS TEMP

SCOTT f894844c34402b67 DEFAULT USERS TEMP

Ops$oracle EXTERNAL DEFAULT USERS TEMP

TOM 0473a0a9140bfbd7 DEFAULT USERS TEMP

Dbsnmp E066D214D5421CCC DEFAULT Sysaux TEMP

Tsmsys 3df26a8b17d0f29f DEFAULT USERS TEMP

DIP ce4a36b8e06ca59c DEFAULT USERS TEMP

Sql> Grant create session to Ops$oracle;

Grant succeeded.

Sql> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-production

With the partitioning, OLAP and Data Mining options

[ORACLE@SOLARIS10 ~] $id

UID=100 (Oracle) gid=100 (Oinstall)

[ORACLE@SOLARIS10 ~] $sqlplus/--login does not need to provide a username and password (Oracle must belong to the OS's DBA group)

Sql*plus:release 10.2.0.2.0-production on Wed Mar 14 16:07:43 2012

Copyright (c) 1982, +, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-production

With the partitioning, OLAP and Data Mining options

Sql> Show User

USER is "ops$oracle"

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/