Oracle creates users and authorizations based on learning 3--oracle

Oracleserver-side operations, such as the following general:

　1) Installing Oracleserver software

2) Create a database (self-created at installation)

3) Configure monitoring (self-configuring when installing)

4) Start Oracle Instance

5) Create user table space

6) Create a new user and authorize

here's how to create a user table space, create a new user, and authorize two items:

　First use the system administrator to log in to Oracle (Sqlplus/as SYSDBA)

? Create user tablespace (d packing folder to create a tablespace named Ts_zhangsan)

Create tablespace ts_zhangsandatafile' D:\zhangsan.dbf 'size30mautoextend on ;

? Create user (username to Zhangsanpassword for PWD)

Create user Zhangsan identified by PWD;

? Grant Tablespace Ts_zhangsan to user Zhangsan

Alter user Zhangsan default Tablespace ts_zhangsan;

? Grant user Zhangsan permissions to connect to the database, create tables, views, manipulate space, and more

Grant Create Session,create table,create view,unlimited tablespace to Zhangsan;

? User Zhangsan Connect to Oracle

Conn Zhangsan/pwd

Note:

? the first thing to do is to authorize the create session and then connect Oracle

? Then you have to authorize tablespace to create the activity

? Then you have to authorize the CREATE Table talent creation table (view same)

? Assuming that all users are authorized, use to public, such as:

Grant Create session to public

? Reclaim permissions with revoke from. e.g. (reverse order and authorization)

Revoke CREATE table from Zhangsan;

Revoke create session from Zhangsan;

? Assuming that the user has a table below, it is not possible to delete (drop) directly, unless the DELETE statement is followed by a cascade to force the deletion, so that all the user-related things are deleted naturally:

　　

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

Oracle creates users and authorizations based on learning 3--oracle