Home » SQL & PL/SQL » SQL & PL/SQL » Privilege Related Doubt (Oracle 9i)
Privilege Related Doubt [message #396384] Mon, 06 April 2009 07:02 Go to next message
swativ80
Messages: 1
Registered: April 2009
Junior Member
When we revoke rights on an object there is a force option. What does that do?
Re: Privilege Related Doubt [message #396385 is a reply to message #396384] Mon, 06 April 2009 07:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Just search....

By
Vamsi
Re: Privilege Related Doubt [message #396386 is a reply to message #396384] Mon, 06 April 2009 07:20 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference,
REVOKE statement

Quote:
Specify FORCE to revoke the EXECUTE object privilege on user-defined type objects with table or type dependencies. You must use FORCE to revoke the EXECUTE object privilege on user-defined type objects with table dependencies.

If you specify FORCE, then all privileges are revoked, all dependent objects are marked INVALID, data in dependent tables becomes inaccessible, and all dependent function-based indexes are marked UNUSABLE. Regranting the necessary type privilege will revalidate the table.

Regards
Michel
Previous Topic: Primary and Foreign Key
Next Topic: Cursor
Goto Forum:
  


Current Time: Sun Dec 04 22:55:55 CST 2016

Total time taken to generate the page: 0.09188 seconds