Re: Revoking grants to public

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Fri, 24 Aug 2012 11:15:20 -0500 (CDT)
Message-ID: <e35b0fcc4966f415a115622662946b2c.squirrel_at_society.servebeer.com>

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

--
http://www.freelists.org/webpage/oracle-l

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

This message: [ Message body ]
Next message: Jeffrey Beckstrom: "Re: Revoking grants to public"
Previous message: Mark W. Farnham: "RE: log file sync (now EBS, RAC, PARALLEL_MAX_SERVERS)"
Maybe in reply to: wblanchard_at_oshkoshcorp.com: "Revoking grants to public"
Next in thread: Jeffrey Beckstrom: "Re: Revoking grants to public"
Reply: Jeffrey Beckstrom: "Re: Revoking grants to public"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message