Create User

建立用户,角色。

CREATE USER user_name

IDENTIFIED BY password;

ALTER USER user_name

IDENTIFIED BY password;

建立角色

CREATE ROLE role_name

角色赋予

GRANT role_name TO user_name [,...]

权限赋予

GRANT privilege [, ...]

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

[WITH GRANT OPTION];

GRANT object_priv [(column [,...])] [,...]

ON object [,...]

TO {user|role|PUBLIC} [,...]

[WITH GRANT OPTION];

参数	描述
privilege	系统权限
user	用户名
role	角色名
PUBLIC	公用角色
WITH GRANT OPTION	权限可转赋
object_priv	对象权限
columns	列名
object	对象名

系统权限	描述
CREATE SESSION	连接数据库
CREATE TABLE	建立表
CREATE SEQUENCE	建立序列
CREATE VIEW	建立视图
CREATE PROCEDURE	建立存储过程

对象权限	TABLE	VIEW	SEQUENCE	PROCEDURE
ALTER	OK		OK
DELETE	OK	OK
EXECUTE		OK		OK
INDEX	OK	OK
INSERT	OK	OK
REFERENCES	OK	OK
SELECT	OK	OK	OK
UPDATE	OK	OK

取消权限

REVOKE {privilege [, privilege...]|ALL}

ON object

FROM {user[, user...]|role|PUBLIC}

[CASCADE CONSTRAINTS];