Home » RDBMS Server » Server Administration » lost roles (oracle10g/solaris10)
lost roles [message #335362] Mon, 21 July 2008 23:44 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Dear All,

We have wrongly dropped roles (resource, dba, connect) in oracle 10g.

Is there a way to recover back the default roles.



Thank you,
Dirish
Re: lost roles [message #335363 is a reply to message #335362] Mon, 21 July 2008 23:46 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
dbms_metadata against valid instance?
Re: lost roles [message #335365 is a reply to message #335363] Mon, 21 July 2008 23:51 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
yes
Re: lost roles [message #335395 is a reply to message #335362] Tue, 22 July 2008 01:07 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sql.bsq file.

Regards
Michel
Previous Topic: how to find all undo tablespace
Next Topic: Help (Sybase)
Goto Forum:
  


Current Time: Wed Dec 07 10:20:34 CST 2016

Total time taken to generate the page: 0.05876 seconds