본문 바로가기

소설과 만화

jazn

$ vi .bash_profile
export  JAVA_HOME=$ORACLE_HOME/jdk
:wq
$ .  .bash_profile
----------------------------------------------------------------------
$ vi  jazn.sh
#!/bin/sh
pushd .
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
popd
:wq
----------------------------------------------------------------------
$ chmod 744 jazn.sh
$ ./jazn.sh
-- add user
JAZN> adduser "iSQL*Plus DBA" expert  expert
-- grant webDba role to user
JAZN> grantrole webDba "iSQL*Plus DBA"  expert
-- webDba 권한자 list
JAZN> listusers "iSQL*Plus DBA"
-- drop user
JAZN> remuser "iSQL*Plus DBA" username
-- revoke webDba role
JAZN> revokerole webDba "iSQL*Plus DBA" username
-- change password
JAZN> setpasswd "iSQL*Plus DBA" username old_password new_password
-- register
JAZN> exit
http://192.168.100.100:5560/isqlplus/dba  > expert/expert

'소설과 만화' 카테고리의 다른 글

SQL*Net & Other Waits  (0) 2011.06.18
ORACLE+PL/SQL  (0) 2011.06.18
EM(database control) & iSQL*Plus  (0) 2011.06.18
오라클 옵티마이저의 기본 원리  (0) 2011.06.18
Parameter file  (0) 2011.06.18