Oracle creates tablespaces, adds users and authorizations, and oracle creates

Oracle creates tablespaces, adds users and authorizations, and oracle creates

Tools/Raw Materials

• PLSQL

Method/step

Https://www.cnblogs.com/wangxuemei/p/1.in plsql, use system/css (orcl system user) to log on. When logging on, the normal user can log on to the system and select normal.

 

2. Oracle users added

Execute the statement create user db_zrrbs identified by css; ---- Add user Password

Note: createuser is the database user created, followed by the user name db_zrrbs, and identifiedby is the css for setting the user password.

3. Grant user authorization

After adding a user, add authorization to the user. In Users, find the newly added user db_zrrbs, right-click to edit the user, and grant the role and system permissions.

Https://www.cnblogs.com/wangxuemei/p/1) Select connect and resource for role permissions.

Of course, you can also select dba. In this way, you do not need to grant other permissions. However, it is recommended that you do not grant dba permissions. The database permissions are too large, which may cause data security risks.

 

2) system permission Selection

 

3) Click Save.

4. Create a tablespace:

Execute the statement create tablespace news_tablespace datafile 'd: \ app \ Administrator \ oradata \ orcl \ news_data.dbf' size 500 M;

Note: news_tablespace is the tablespace name created, and news_data.dbf is the path for storing. dbf Files. You must set it in advance.