Grand the WEBDBA ROLE to the USER


 Grand the WEBDBA ROLE to the USER:-

http://sujeet:5560/isqlplus/dba
USER:-sys
Password:-oracle
Connect Identifier:-orcl
Privilege :-sysdba


[oracle@sujeet ~]$ cd /10g/app/oracle/product/10.2.0/db_1/oc4j/j2ee/isqlplus/application-deployments/isqlplus


[oracle@sujeet isqlplus]$ /usr/java/jre1.6.0_20/bin/java -Djava.security.properties=/10g/app/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell

JAZN:>
JAZN:> adduser "iSQL*Plus DBA" sujeet sujeet

JAZN:> grantrole webDba "iSQL*Plus DBA" sujeet

JAZN:> listusers "iSQL*Plus DBA"
sujeet
admin

JAZN:> exit
JAZN:>

[oracle@sujeet isqlplus]$

No comments:

How to add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...