Re: Revoking grants to public
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Aug 2012 11:15:20 -0500 (CDT)
Howdy WGB,
> I'm in the process of locking down our databases and I noticed that all of
> our databases have grants to public on almost all of the tables in the
> database including the sys and system tables. I think I know the answer
> but I'm hoping for confirmation that I can revoke the grants to public
> without affecting the database (I have granted access via roles to the
> user accounts)
Be careful with that. MOS 247093.1 says so, anyway. Search on MOS for
"revoke public" (sans quotes) and you'll find a whole lotta articles on the
topic.
GL!
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
