Home » RDBMS Server » Security » Revoking the GRANT OPTION from PUBLIC
Revoking the GRANT OPTION from PUBLIC [message #289223] Thu, 20 December 2007 05:34 Go to next message
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.
Re: Revoking the GRANT OPTION from PUBLIC [message #289230 is a reply to message #289223] Thu, 20 December 2007 06:26 Go to previous messageGo to next message
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,
Re: Revoking the GRANT OPTION from PUBLIC [message #289257 is a reply to message #289223] Thu, 20 December 2007 07:56 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: Problems with database vault
Next Topic: Regarding Security Patch
Goto Forum:
  


Current Time: Thu Mar 28 16:12:48 CDT 2024