创建用户:
CREATE USER user_name IDENTIFIED BY password
[DEFAULT TABLESPACE default_tablespace]
[temporary TABLESPACE temporary_tablespace]
修改用户密码:
ALTER USER jason IDENTIFIED BY marcus
PASSWORD 修改当前登录用户的密码。
删除用户:
DROP USER jason
向用户授予系统特权:
GRANT CREATE SESSION,EXECUTE ANY PROCEDURE TO steve WITH ADMIN OPTION
WITH ADMIN OPTION :所授权的用户可以将这种特权再授予其他用户。
检查授予用户的系统特权:
SELECT *
FROM user_sys_privs;
ORDER BY privilege;
撤销用户的系统特权:
REVOKE CREATE TABLE FROM steve;
向用户授予对象特权:
GRANT SELECT,INSERT,UPDATE ON store.product s TO steve WITH GRANT OPTION;(WITH GRANT OPTION所授权的用户就可以把这种特权)
撤销用户的对象特权:
REVOKE INSERT ON produ