常用创建用户的脚本
----脚本:
---------------------------------------------------------------------------------
---创建用户
CREATE USER "USER" PROFILE "DEFAULT" IDENTIFIED BY "PASSWORD"
DEFAULT TABLESPACE "TABES"
TEMPORARY TABLESPACE "TABESTEMP"
ACCOUNT UNLOCK;
---------------------------------------------------------------------------------
---用户授权
GRANT ALTER ANY MATERIALIZED VIEW TO "USER";
GRANT CREATE ANY MATERIALIZED VIEW TO "USER";
GRANT CREATE ANY VIEW TO "USER";
GRANT CREATE MATERIALIZED VIEW TO "USER";
GRANT CREATE VIEW TO "USER";
GRANT DROP ANY MATERIALIZED VIEW TO "USER";
GRANT DROP ANY VIEW TO "USER";
GRANT MERGE ANY VIEW TO "USER";
GRANT SELECT ANY DICTIONARY TO "USER";
GRANT UNDER ANY VIEW TO "USER";
GRANT UNLIMITED TABLESPACE TO "USER";
GRANT "CONNECT" TO "USER";
GRANT "RESOURCE" TO "USER";
---------------------------------------------------------------------------------
---提交
COMMIT;
-------------------------------------------------------------------------------
/*
以上是比较常用的建立用户及授权的语句。(user:用户名,password:密码,USER:表空间,TABESTEMP:临时表空间)
请注意，你首先要确认你的数据库里是否有这二个表空间：表空间USER和临时表空间TABESTEMP。如果没有，你先要创建他们TABES,TABESTEMP，然后再创建用户。
当你创建用户时，应该定义它的表空间(default tablespace)。否则，它会使用系统表空间(system tablespace)。这是应该避免的。
*/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/295691/viewspace-211639/ ，如需转载，请注明出处，否则将追究法律责任。
