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

create_user.sql

set term offset echo offset feedback offcreate user &&1 identified by &&2default tablespace userstemporary tablespace tempquota &&3.M on users;grant connect,resource to &&1;

 

 

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