Detailed Oracle to establish user and user management

# Legal Oracle Identification symbol

1, cannot be reserved keyword

2, must use 1 to 30 characters. The name of the database is up to 8 characters.

3, must start with the letter character in the database character set

4. Can only contain alphabetic characters in the database character set, and the following characters: #, $, _, the other database links can contain the @ symbol and '. ' Period

5, cannot contain quotation marks

# Create a user

Create user Angeos identified by Angeos;

Established the User: Angeos, the password is: Angeos

# Authorization to the user

Grant Connect,resource to Angeos;

User Angeos granted permission to connect to the database and access resources

# Authorization to the user

Grant create SESSION,DBA to Angeos;

The CREATE session is a system privilege that provides users with the ability to connect to a database.

The DBA is a role with more than 120 system privileges, so it allows users to do almost anything in the database.

# Change the user's password

Alter user Angeos identified by Oracle, changing the password of the user Angeos to: Oracle.

# Lock account and Unlock

Alter user OE account unlock;

Then log on to the database server with the user OE, and the password is OE. Note: After the user unlocks, restart the service.

# Modify the table space settings

By default, it uses tablespace system and TEMP (for temporary data storage).

This method is not recommended. So we need to change the table space.

Connecting to a database server through a system user

conn　sys/sysadmin@hostname_services　as　sysdba;

Then look at the table space

select　tablespace_name,contents　from　dba_tablespaces
order　by　tablespace_name;

Using the user table space instead of the system table space

alter　user　angeos　default　tablespace　users
temporary　tablespace　temp;