Re: Revoking grants to public

From: Rich Jesse <>
Date: Fri, 24 Aug 2012 11:15:20 -0500 (CDT)
Message-ID: <>

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.



Received on Fri Aug 24 2012 - 11:15:20 CDT

Original text of this message