Test environment: win2003 + oracle10gr2
Set environment variables:
Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1
Set java_home = % ORACLE_HOME % \ JDK
Set Path = % java_home % \ bin; % PATH %
Go to the ISQLPLUS directory:
Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS
Enter the jazn command environment:
Java-djava. security. properties = % ORACLE_HOME %/sqlplus/admin/iplus/provider-jar % ORACLE_HOME %/Solaris/J2EE/home/jazn. jar-user "iSQL * Plus DBA/admin"-Password welcome-shell
List users:
Jazn:> listusers "iSQL * Plus dba"
Create a user (username: tsys01; Password: Oracle ):
Jazn:> adduser "iSQL * Plus dba" tsys01 Oracle
Authorize the user to log on to ISQLPLUS DBA
Jazn:> grantrole webdba "iSQL * Plus dba" tsys01
After exiting the jazn environment, tsys01 can take effect. That is, tsys01 can log on to ISQLPLUS as sysdba:
Jazn:> exit
Test (enter the following URL and a dialog box will pop up. Enter the newly created user tsys01 and the password oracle. Then, you can enter the user name and password on the web page as required ):
Http: // duzz: 5560/isqlplus/DBA
Http: // ipaddr: Port/isqlplus/DBA
Supplement:
If you find that adding or granting or revoking permissions does not work, you can try to exit the jazn environment first.
Stop and start the ISQLPLUS Server:
Isqlplusctl stop
Isqlplusctl start
Revoke the user's permission to log on to ISQLPLUS DBA
Jazn:> revokerole webdba "iSQL * Plus dba" tsys01
Delete a user
Jazn:> remuser "iSQL * Plus dba" tsys01
Change User Password (Change Password of user tsys01 from Oracle to oracle01)
Jazn:> setpasswd "iSQL * Plus dba" tsys01 Oracle oracle01
Ref:
Http://www.ningoo.net/html/2007/how_to_login_isqlplus_as_a_dba.html