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

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.

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

SQL> DROP ROLE resource;

Role dropped.

Best regards.

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

Current Time: Sun Mar 03 09:04:06 CST 2024