如果是oracle用户登录来执行脚本,下面的脚本即可USER=tony PASSWORD=oraclesqlplus -S /nolog > sqlplus.log 2>&1 <<EOF conn / as sysdba create user $USER identified by $PASSWORD; grant connect,resource to $USER; EOF如果不是oracle用户,需要知道有DBA权限的数据库用户/密码, SYSUSER=sys SYSPASSWORD=oracle USER=tony PASSWORD=oraclesqlplus -S /nolog > sqlplus.log 2>&1 <<EOF conn $SYSUSER/$SYSPASSWORD as sysdba create user $USER identified by $PASSWORD; grant connect,resource to $USER; EOF
http://blog.csdn.net/java3344520/article/details/7205306
http://blog.csdn.net/java3344520/article/details/7205306
PASSWORD=oraclesqlplus -S /nolog > sqlplus.log 2>&1 <<EOF
conn / as sysdba
create user $USER identified by $PASSWORD;
grant connect,resource to $USER;
EOF如果不是oracle用户,需要知道有DBA权限的数据库用户/密码,
SYSUSER=sys
SYSPASSWORD=oracle
USER=tony
PASSWORD=oraclesqlplus -S /nolog > sqlplus.log 2>&1 <<EOF
conn $SYSUSER/$SYSPASSWORD as sysdba
create user $USER identified by $PASSWORD;
grant connect,resource to $USER;
EOF