创建帐号:
CREATE USER username PROFILE DEFAULT --指定用户名
IDENTIFIED BY pwd --指定密码
DEFAULT TABLESPACE uses --指定改用户所用的表空间名字
ACCOUNT UNLOCK; --设置帐号是否锁定
锁定帐号:
ALTER USER username ACCOUNT LOCK;
解锁帐号:
ALTER USER username ACCOUNT UNLOCK;
修改密码:
ALTER USER username IDENTIFIED BY new_pwd;
删除用户:
DROP USER username CASCADE;
给帐号授权:
GRANT "resource" TO username;
GRANT "connect" TO username;
删除帐号的某个权限:
REVOKE "resource" FROM username;