create user username identified by password default tablespace users quota unli
mited on users;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO 用户名;
[url]http://www.blogjava.net/wolfman09/archive/2009/05/01/268536.html[/url]
mited on users;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO 用户名;
[url]http://www.blogjava.net/wolfman09/archive/2009/05/01/268536.html[/url]