Removing ALL_ views from users

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 30 Mar 2009 09:32:28 -0500

List,

Some security auditors are stating that the ALL_ views are a security risk
and are recommending that I revoke them. In particular, they are pointing to
ALL_USERS as offering a hacker useful information. My guess is that the ALL_
views are granted to PUBLIC. Has anyone had this requirement? Has anyone
successfully revoked this access?

Dennis

Other related posts: