Home » RDBMS Server » Server Administration » revoke privilages from public (oracle 10g)
revoke privilages from public [message #433372] Wed, 02 December 2009 00:07 Go to next message
snsiddiqui
Messages: 166
Registered: December 2008
Senior Member
I want to revoke privileges on powerful packages from PUBLIC role but how?
any helpful information will be highly appreciated.
Re: revoke privilages from public [message #433380 is a reply to message #433372] Wed, 02 December 2009 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using REVOKE statement maybe?
Take care that revoking something standard (that is delivered with the version) from PUBLIC is not supported by Oracle and needs its backing and in anyway it is mandatory you grant them back before applying any patch/patchset/PSU/CPU...

Regards
Michel
Re: revoke privilages from public [message #433383 is a reply to message #433380] Wed, 02 December 2009 00:55 Go to previous messageGo to next message
snsiddiqui
Messages: 166
Registered: December 2008
Senior Member
MICHEL thanks for the reply but I need to know how many powerful packages or any other objects are assigned to PUBLIC.

I think there might be a big list of packages/obects of PUBLIC then my question is
will I revoke privileges one by one or is there any other way to revoke all privileges in a single statement.
Re: revoke privilages from public [message #433385 is a reply to message #433383] Wed, 02 December 2009 00:59 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to revoke one by one.
And it should be very dangerous to be able to do it for all privileges in a single shot, above all for PUBLIC, then your database will work for only ONE "user": SYS.

Regards
Michel
Previous Topic: A lot of ORA-errors from time to time on different databases
Next Topic: Do not alter user's Trigger ?
Goto Forum:
  


Current Time: Tue Sep 27 11:06:09 CDT 2016

Total time taken to generate the page: 0.10853 seconds