Oracle 10g isqlplus DBA Access Howto

Oracle 10g: Enable isqlplus DBA Access


1. Change Directory to
$ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus

2. Start JAZN Shell
$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:
$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
-adduser "iSQL*Plus DBA" username password

4. Grant access for iSQL*Plus DBA user
grantrole webDba "iSQL*Plus DBA" username


5. JAZN Shell sample commands:

JAZN:>listusers
JAZN:>adduser "iSQL*Plus DBA" username password
JAZN:>grantrole webDba "iSQL*Plus DBA" username
JAZN:>remuser "iSQL*Plus DBA" username
JAZN:>revokerole webDba "iSQL*Plus DBA" username
JAZN:>setpasswd "iSQL*Plus DBA" username old_pass new_pass