Sunday, March 9, 2008

4-10. Setting up iSQL*PLUS for SYSDBA and SYSOPER access

For a user to login to iSQL*PLUS as SYSDBA or SYSOPER you must set up the user in the OC4J user manager by performing the following steps:
  1. Create a user
  2. Grant the webDba role to the user




$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
$ $JAVA_HOME/bin/java -Djava.security.properties=$ORACLE_HOME/oc4j/j2ee/home/config/jazn.security.props -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell

JAZN> add user "iSQL*Plus DBA" username password
JAZN> grantrole webDba "iSQL*Plus DBA" username
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)