Introduction to Oracle user creation syntax

Oracle user creation operations are familiar to everyone. The following describes the syntax of Oracle user creation, and hopes to help you learn about Oracle user creation.

Syntax for creating a user in Oracle:

Oracle creates a USER password to verify the USER), you can use the create user command.

Create user username identified by password

OR IDENTIFIED EXETERNALLY

Or identified globally as 'cn = user'

[Default tablespace tablespace]

[Temporary tablespace temptablespace]

[QUOTA [integer K [M] [UNLIMITED] ON tablespace

[, QUOTA [integer K [M] [UNLIMITED] ON tablespace

[PROFILES profile_name]

[Password expire]

[Account lock or account unlock]

Where,

Create user username: USER name, which is generally in the alphanumeric format and the "#" and "_" symbols.

Identified by password: the user's password, which is generally in the alphanumeric format and "#" and.

Identified exeternally: indicates that the user name is verified under the operating system. The user name must be the same as the user name defined in the operating system.

Identified globally as 'cn = user': the user name is verified by the Oracle Security Domain Center Server. The CN name indicates the user's external name.

[Default tablespace tablespace]: The default tablespace.

[Temporary tablespace tablespace]: The default temporary tablespace.

[QUOTA [integer K [M] [UNLIMITED] ON tablespace: the number of bytes in a table space that you can use.

[PROFILES profile_name]: name of the resource file.

[Password expire]: Set the PASSWORD to expired immediately. You must change the PASSWORD before logging on again.

[Account lock or account unlock]: whether the user is locked. By default, it is not locked.
 

Oracle Default User Password Problems

Show you the Oracle explicit cursor

Use instances of Oracle stored procedures

Oracle command line custom editor vi

Implementation of oracle command line Logon