@echo on
sqlplus system/sys
conn /as sysdba
drop user his45 cascade;
create user his45 identified by his;
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 his45;
但是执行第一句sqlplus system/sys 后
就切换到SQL> 后面语句要手动输入才行
能不能直接一个批处理搞定? 各位大虾帮忙,非常感谢 ,最好能写的详细一点,小弟是菜鸟,复杂了看不懂
sqlplus system/sys
conn /as sysdba
drop user his45 cascade;
create user his45 identified by his;
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 his45;
但是执行第一句sqlplus system/sys 后
就切换到SQL> 后面语句要手动输入才行
能不能直接一个批处理搞定? 各位大虾帮忙,非常感谢 ,最好能写的详细一点,小弟是菜鸟,复杂了看不懂
sqlplus system/sys@??? @sqlfile.sql2、建sqlfile.sql文件,内容是:
drop user his45 cascade;
create user his45 identified by his;
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 his45;
3、运行filename.bat即可。
先编写好要执行的语句,比如文件名为createuser.sql
执行:
sqlplus user/passwd@dbname @d:\scripts\createuser.sql
create user his45 identified by his;
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 his45;
exit
加个exit 上面这段写成.sql 文件@echo on
sqlplus system/sys@服务名 @.sql的路径名 就可以了 我已经试过,肯定可以