Home » RDBMS Server » Security » role problem !
role problem ! [message #14762] Wed, 08 September 2004 00:29 Go to next message
Naveen
Messages: 75
Registered: June 2001
Member
I have granted select,update,insert to a role called MANAGER ,now i want to withdraw update from the role. How can i do it ?

Report message to a moderator

Re: role problem ! [message #14767 is a reply to message #14762] Wed, 08 September 2004 01:29 Go to previous messageGo to next message
Raghavendra
Messages: 69
Registered: December 2000
Member
hello,

U can revoke update from role as follows...

Revoke update from Manager;

Report message to a moderator

Re: role problem ! [message #14768 is a reply to message #14762] Wed, 08 September 2004 01:46 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You'll need the ADMINISTER DATABASE TRIGGER system privilege.

MHE

Report message to a moderator

Sorry, wrong thread [message #14769 is a reply to message #14768] Wed, 08 September 2004 01:47 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
n/t

MHE

Report message to a moderator

Previous Topic: Oracle Security
Next Topic: AUDIT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 17:09:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.