OraFAQ Forum: Security » Revoking the GRANT OPTION from PUBLIC

Home » RDBMS Server » Security » Revoking the GRANT OPTION from PUBLIC

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Revoking the GRANT OPTION from PUBLIC [message #289223]

Thu, 20 December 2007 05:34

veugelenw
Messages: 1
Registered: December 2007
Location: Belgium

Junior Member

Hi,

If object privileges granted to the PUBLIC role in an Oracle database are assigned with the WITH GRANT OPTION, is it possible to revoke/ the WITH GRANT OPTION?

I do not understand why object privileges assigned to PUBLIC would require this specific configuration? Can somebody clarify this for me?

Thanks in advance.

Report message to a moderator

Re: Revoking the GRANT OPTION from PUBLIC [message #289230 is a reply to message #289223]

Thu, 20 December 2007 06:26

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

you don't need to grant the WITH GRANT OPTION when you are granting privileges.you can just use:

GRANT privileges on OBJECT_NAME TO user_name.

regards,

Report message to a moderator

Re: Revoking the GRANT OPTION from PUBLIC [message #289257 is a reply to message #289223]

Thu, 20 December 2007 07:56

Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can't revoke ONLY the grant option. You have to revoke the whole privilege and re-grant it without the grant option.

Regards
Michel

Report message to a moderator

Previous Topic:	Problems with database vault
Next Topic:	Regarding Security Patch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 20 08:00:43 CDT 2022