Oracle DBA: Add a DBA user for SQL plus (iSQL * Plus)

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