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: 232
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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
dbms_metadata against valid instance?

Report message to a moderator

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: 232
Registered: November 2006
Senior Member
yes

Report message to a moderator

Re: lost roles [message #335395 is a reply to message #335362] Tue, 22 July 2008 01:07 Go to previous message
Michel Cadot
Messages: 68672
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sql.bsq file.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 07 00:53:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.