Revoking grants to public

From: <>
Date: Fri, 24 Aug 2012 10:20:21 -0500
Message-ID: <>

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)

Thank you,

WGB Although this e-mail and any attachments are believed to be free of any virus or other defect which might affect any computer system, it is the responsibility of the recipient to check that it is virus-free and the sender accepts no responsibility or liability for any loss, injury, damage, cost or expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential information and intended only for the use of the individual or entity named above, and may be privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, please contact the sender immediately, delete this material from your computer and destroy all related paper media. Please note that the documents transmitted are not intended to be binding until a hard copy has been manually signed by all parties. Thank you.

Received on Fri Aug 24 2012 - 10:20:21 CDT

Original text of this message