一、创建用户
-- 以SYSTEM用户登录
SQLPLUS SYSTEM/密码 AS SYSDBA;
-- 执行创建命令
CREATE USER 用户名 IDENTIFIED BY 密码 ;
二、赋权用户
GRANT
CREATE USER, DROP USER,ALTER USER, CREATE ANY VIEW, DROP ANY VIEW, CREATE ANY INDEX,
DROP ANY INDEX, CREATE ANY PROCEDURE, DROP ANY PROCEDURE, ALTER ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE,
EXP_FULL_DATABASE,IMP_FULL_DATABASE, CREATE SESSION, DBA, CONNECT, RESOURCE
TO 用户名;
三、解锁用户
ALTER USER 用户名 ACCOUNT UNLOCK;
四、删除用户
-- 删除用户和其所有的对象
DROP USER 用户名 CASCADE;