Log on to the dba user under Oracle10gisqlplus

Welcome to the Oracle Community Forum, interact with 2 million technical staff to enter the Oracle10gisqlplus login dba users may not know, set as follows: oracleisqlplusdba account settings: 1, cd $ ORACLE_HOMEoc4jj2eeisqlplusapplication-deploymentsisqlplus2, $ ORACLE_HOMEj

Welcome to the Oracle community forum and interact with 2 million technical staff> go to Oracle10gisqlplus and log on to the dba. Many users may not know the settings as follows: oracle isqlplus dba account settings: 1. cd $ ORACLE_HOME/Solaris/j2ee/isqlplus/application-deployments/isqlplus 2, $ ORACLE_HOME/j

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Log on to the dba user under Oracle10gisqlplus
Many people may not know how to set it as follows:

Oracle isqlplus dba account settings:
1,
Cd $ ORACLE_HOME/Solaris/j2ee/isqlplus/application-deployments/isqlplus

2,
$ ORACLE_HOME/jdk/bin/java-Djava. security. properties = $ ORACLE_HOME/Solaris/j2ee/home/config/jazn. security. props-jar $ ORACLE_HOME/Solaris/j2ee/home/jazn. jar-user "iSQL * Plus DBA/admin"-password admin_password-shell

3. Operation:
1> create a user
JAZN:> adduser "iSQL * Plus DBA" username password
2> User List
JAZN:> listusers "iSQL * Plus DBA"
3> grant webdba Permissions
JAZN:> grantrole webDba "iSQL * Plus DBA" username
4> delete a user
JAZN:> remuser "iSQL * Plus DBA" username
5> revoke the webdba permission
JAZN:> revokerole webDba "iSQL * Plus DBA" username
6> Change Password
JAZN:> setpasswd "iSQL * Plus DBA" username old_password new_password

After setting the preceding steps, isqlplus needs to be restarted.