1. 创建新用户及设置密码：CREATE USER 用户名 IDENTIFIED BY '密码' DEFAULT TABLESPACE 表空间名 ACCOUNT UNLOCK；
  2. 修改用户密码：ALTER USER 用户名 IDENTIFIED BY 新密码；
  3. 用户权限赋予：GRANT CONNECT, RESOURCE, SELECT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE, INSERT ANY TABLE, SELECT ANY DICTIONARY, CREATE ANY PROCEDURE, EXECUTE ANY PROCEDURE, CREATE ANY TRIGGER, CREATE ANY VIEW, UNLIMITED TABLESPACE, DROP ANY VIEW, CREATE ANY SEQUENCE, SELECT ANY SEQUENCE, DROP ANY SEQUENCE, CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK, DROP PUBLIC DATABASE LINK, CREATE ANY SYNONYM, DROP ANY SYNONYM, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM, SELECT_CATALOG_ROLE TO 用户名；
  4. 用户权限回收：REVOKE 角色名 FROM 用户名；
  5. 删除用户：DROP USER 用户名 CASCADE；