Home » RDBMS Server » Security » Missing Roles
icon5.gif  Missing Roles [message #137038] Mon, 12 September 2005 21:53 Go to next message
rebeccaz
Messages: 18
Registered: August 2005
Junior Member
Hi,

Can someone kindly advise why the roles like DBA, CONNECT, RESOURCE, etc can disappear from my database? These resulted in connection problems when I try to login as other schema users.
Thank in advance.

Regards,
Rebecca
Re: Missing Roles [message #137130 is a reply to message #137038] Tue, 13 September 2005 07:04 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
There is only one way! Somebody did this -

SQL> DROP ROLE resource;

Role dropped.


Best regards.

Frank
Previous Topic: any password works!!!
Next Topic: Making packages visible to another user - Urgent
Goto Forum:
  


Current Time: Fri Mar 29 02:36:54 CDT 2024