oracle 10g 的iSQL*Plus DBA 怎么用

aquino

跟9i不太一样了

aquino

[quote]原帖由 "aquino"]跟9i不太一样了[/quote 发表：


学会了，向大家报告一下

1. Change Directory to

1. cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus

复制代码

2. Start JAZN Shell

1. $JAVA_HOME/bin/java -Djava.security.properties=$ORACLE_HOME/sqlplus/admin/iplus/provider -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar -user "iSQL*Plus DBA/admin" -password admin_password -shell

复制代码

       
        the "admin_password" is set to "welcome" by default

3. To create a user from the command-line, enter:

1. JAZN:>;adduser "iSQL*Plus DBA" username password

复制代码

4. Grant access for iSQL*Plus DBA user

1. JAZN:>;grantrole webDba "iSQL*Plus DBA" username

复制代码

OK now :http://localhost:5560/isqlplus/dba

5. JAZN Shell sample commands:

1.         JAZN:>;listusers
   
2.         JAZN:>;adduser "iSQL*Plus DBA" username password
   
3.         JAZN:>;grantrole webDba "iSQL*Plus DBA" username
   
4.         JAZN:>;remuser "iSQL*Plus DBA" username
   
5.         JAZN:>;revokerole webDba "iSQL*Plus DBA" username
   
6.         JAZN:>;setpasswd "iSQL*Plus DBA" username old_password new_password

复制代码

feiaix

需要这么麻烦吗?有没有简单点的办法?