重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 【课堂笔记】【SQL】12.Controlling User Access [打印本页]

作者: 5dm 时间: 2012-11-1 17:37
标题: 【课堂笔记】【SQL】12.Controlling User Access
创建用户的基本语法：

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 时间: 2012-11-2 15:12

Object
Privilege Table View Sequence Procedure

ALTER ? ?

DELETE ? ?

EXECUTE ?

INDEX ?

INSERT ? ?

REFERENCES ?

SELECT ? ? ?

UPDATE ? ?

作者: 5dm 时间: 2012-11-2 15:13

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

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)