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