【课堂笔记】【SQL】12.Controlling User Access

5dm

创建用户的基本语法： 

CREATE USER user                 

IDENTIFIED BY   password;

 

用户授权基本语法： 

GRANT privilege [, privilege...]

TO user [, user| role, PUBLIC...];

 

系统权限包括： 

–CREATE SESSION

–CREATE TABLE

–CREATE SEQUENCE

–CREATE VIEW

–CREATE PROCEDURE

 

 

 

5dm

 

Object
Privilege Table       View Sequence Procedure

ALTER  ?                                       ?

DELETE    ?     ?

EXECUTE                                                              ?

INDEX    ?

INSERT     ?     ?

REFERENCES           ?    

SELECT     ?     ?       ?

UPDATE     ?     ?

5dm

 

Data Dictionary View	Description
ROLE_SYS_PRIVS	System privileges granted to roles
ROLE_TAB_PRIVS	Table privileges granted to roles
USER_ROLE_PRIVS	Roles accessible by the user
USER_TAB_PRIVS_MADE	Object privileges granted on the user’s objects
USER_TAB_PRIVS_RECD	Object privileges granted to the user
USER_COL_PRIVS_MADE	Object privileges granted on the columns of the user’s objects
USER_COL_PRIVS_RECD	Object privileges granted to the user on specific columns
USER_SYS_PRIVS	System privileges granted to the user