SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GRANT DBA ?

495612Mar 11 2006 — edited Mar 12 2006

Hi Friends,
Can a Non-DBA user be granted himself as DBA? If not, then how it happens here.
SQL> CONNECT JAMES / XXXXX
SQL> SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS
WHERE USERNAME='JAMES'
/
GRANTED_ROLE
--------------------------
CONNECT
DBA
RESOURCE
SQL> REVOKE DBA FROM JAMES ;
----------- Now JAMES user's not having DBA role...
SQL> GRANT DBA TO JAMES;
-------Point is how JAMES user itself granted DBA role, whereas he has been REVOKED as DBA.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2006

Added on Mar 11 2006

6 comments

422 views