Oracle User Management

Oracle Default database user

When a new database is created, Oracle automatically creates 3 database users for us.

1.sys User:

SYS user is a super User in Oracle. All data dictionaries and views in the database are stored in the SYS mode (what is the schema?). )

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. SYS users are primarily used to maintain system information and manage instances.

　　　　　　　　SYS users can only log on to the system in SYSDBA or Sysoper roles .

2.System Users:

The system user is the default sysadmin in Oracle, and it has DBA authority. This user has the built-in tables and views used by Oracle management tools. Typically through the system user tube

Users, permissions, and storage for Oracle databases. Creating a user table in system mode is not recommended.

System users cannot log on to systems with the SYSDBA or Dydoper role and can only log on by default .

3.Scott Users:

The Scott user is a model user of the Oracle database, which is typically created when the database is installed. The Scott user mode contains four demonstration tables, one of which is the EMP table. Using the Users Table

The spatial storage mode object.

Create user

CREATE user User identified by pwd
DEFAULT tablespace tablespace
Temporary tablespace Temp
[QUOTA UNLIMITED on qu]
[QUOTA 10M on qo]
[PASSWORD EXPIRE];

Explain:

User is the username.

The PWD is the user's password.

The tablespace is the user's default table space.

Temp is the user temp table space.

Qu and Qo are the number of table space bytes that the user can use.

The last line is to immediately set the password to an out-of-date state and the password must be changed before the user logs on.

Query users

SELECT * from Dba_users
WHERE username= 'name';

Explain:

Name is the user name you want to query.

View user's tablespace quotas

SELECT * from Dba_ts_quotas
WHERE username= 'name';

Explain:

Name is the user name.

change user quotas in table spaces

ALTER USER username QUOTA 20M on tablespace;

Explain:

Username is the user name.

Tablespace is the table space name.

Oracle User Management