1. 用戶(hù)操作：
創(chuàng)建：
- CREATE USER user
- IDENTIFIED {BY password | EXTERNALLY}
- [DEFAULT TABLESPACE tablespace]
- [TEMPORARY TABLESPACE tablespace]
- [QUOTA {integer [K|M] | UNLIMITED} ON tablespace]
- [PROFILE profile]
修改：
- ALTER USER user
- [IDENTIFIED {BY password | EXTERNALLY}]
- [DEFAULT TABLESPACE tablespace]
- [TEMPORARY TABLESPACE tablespace]
- [QUOTA {integer [K|M] | UNLIMITED} ON tablespace]
- [PROFILE profile]
- [DEFAULT ROLE { role [, role] ...
- | ALL [EXCEPT role [, role] ...] | NONE}]
刪除：
- DROP USER user_name [CASCADE]
授權(quán)，撤銷(xiāo)權(quán)限：
- GRANT role TO user [WITH ADMIN OPTION]
-
- REVOKE role FROM user
系統(tǒng)允許 賦于整個(gè)系統(tǒng)的權(quán)限給用戶(hù)，角色等：
- GRANT system_privilege TO {user_name | role | PUBLIC}
- [WITH ADMIN OPTION]
如果使用了WITH ADMIN OPTION 選項(xiàng)就允許擁有該權(quán)限的人將該權(quán)限應(yīng)用給其它
的用戶(hù)。
你可以使用下邊的GRANT 語(yǔ)句來(lái)對(duì)其它用戶(hù)授權(quán)訪(fǎng)問(wèn)你的表
- GRANT {object_priv | ALL [PRIVILEGES]} [ (column
- [, column]...) ]
- [, {object_priv | ALL [PRIVILEGES]} [ (column
- [, column] ...) ] ] ...
- ON [schema.]object
- TO {user | role | PUBLIC} [, {user | role | PUBLIC}] ...
- [WITH GRANT OPTION]
如果你想取消對(duì)某個(gè)對(duì)象對(duì)于某人的授權(quán)你可以使用REVOKE 語(yǔ)句語(yǔ)法如下
- REVOKE {object_priv | ALL [PRIVILEGES]}
- [, {object_priv | ALL [PRIVILEGES]} ]
- ON [schema.]object
- FROM {user | role | PUBLIC} [, {user | role | PUBLIC}]
- [CASCADE CONSTRAINTS]