Re: grant select on SCOTT.* to vewalluser;

From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
To: davidsharples@xxxxxxxxx
Date: Tue, 31 Oct 2006 11:53:15 -0600

Roger,

The alternative is to grant select any table to that user. Someday an
auditor will probably tell your boss you're incompetent, but take that as a
badge of honor.

If you are really serious about this, Asktom provides a workaround:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:646423863863

Another thought is to use roles. Have a practice that whenever a new table
is created, someone grants that table to the role. At least somebody has
reviewed the grant, and it isn't "hidden".

Security is often the bane of convenience.

Dennis Williams

References:

RE: grant select on SCOTT.* to vewalluser;
From: Roger Xu

Re: grant select on SCOTT.* to vewalluser;
From: David Sharples

Re: grant select on SCOTT.* to vewalluser;

Other related posts: