CREATE USER fao
IDENTIFIED BY fao
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for FAO
GRANT AQ_ADMINISTRATOR_ROLE TO fao WITH ADMIN OPTION;
GRANT CONNECT TO fao WITH ADMIN OPTION;
GRANT DBA TO fao WITH ADMIN OPTION;
ALTER USER fao DEFAULT ROLE ALL;
-- 1 System Privilege for FAO
GRANT UNLIMITED TABLESPACE TO fao WITH ADMIN OPTION;
-- 5 Tablespace Quotas for FAO
ALTER USER fao QUOTA UNLIMITED ON USERS;
ALTER USER fao QUOTA UNLIMITED ON TEMP;
ALTER USER fao QUOTA UNLIMITED ON INDX;
--ALTER USER fao QUOTA UNLIMITED ON RBS;
ALTER USER fao QUOTA 6M ON SYSTEM;
--删除用户实例
drop user test cascade
--解除锁定用户
alter user scott account unlock
--修改失效密码
alter user scott identified by tiger
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载