建立用户并授予权限的简单脚本

create_user.sql

set term off set echo off set feedback off create user &&1 identified by &&2 default tablespace users temporary tablespace temp quota &&3.M on users; grant connect,resource to &&1;

 

 

执行 spool 2010-2-21.log @create_user.sql test_name password quota_size spool off