Home » RDBMS Server » Security » Oracle system created DBA role dropped by accident
Oracle system created DBA role dropped by accident [message #54908] Sat, 14 December 2002 08:41 Go to next message
yan fei
Messages: 1
Registered: December 2002
Junior Member
Oracle system created DBA role was dropped by accident, several account cannot login because of no CREATE SESSION privs etc. How do I recover it?

Is it so that I only need to re-create the DBA role and grant necessary privs to it(I can find this in sql.bsq), then grant this DBA role to whatever other users and roles which need it.

Thanks,

Report message to a moderator

Re: Oracle system created DBA role dropped by accident [message #54913 is a reply to message #54908] Sun, 15 December 2002 06:28 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the role DBA is created by sql.bsq script.
so, just execute the following logged in as sys. 

SQL> create role dba;          
SQL> grant all privileges to dba with admin option;          
SQL> grant select_catalog_role to dba with admin option;          
SQL> grant execute_catalog_role to dba with admin option;          
SQL> grant delete_catalog_role to dba with admin option;

Report message to a moderator

Previous Topic: Why dose a user granted dba role do not has select any table privilege in procedure?
Next Topic: Audit Trail
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 03:06:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.