1. 用戶操作：
創建：
- 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]
授權，撤銷權限：
- GRANT role TO user [WITH ADMIN OPTION]
-
- REVOKE role FROM user
系統允許 賦于整個系統的權限給用戶，角色等：
- GRANT system_privilege TO {user_name | role | PUBLIC}
- [WITH ADMIN OPTION]
如果使用了WITH ADMIN OPTION 選項就允許擁有該權限的人將該權限應用給其它
的用戶。
你可以使用下邊的GRANT 語句來對其它用戶授權訪問你的表
- 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]
如果你想取消對某個對象對于某人的授權你可以使用REVOKE 語句語法如下
- REVOKE {object_priv | ALL [PRIVILEGES]}
- [, {object_priv | ALL [PRIVILEGES]} ]
- ON [schema.]object
- FROM {user | role | PUBLIC} [, {user | role | PUBLIC}]
- [CASCADE CONSTRAINTS]