Re: Does Oracle Have Anything Similar to SqlServer "Deny" Attribute?

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: rjamya@xxxxxxxxx
  • Date: Thu, 19 Apr 2007 16:41:23 -0700

On 4/19/07, rjamya <rjamya@xxxxxxxxx> wrote:

Sam,

Like David said, Database Vault is a solution but it isn't cheap either.
Your better bet might be VPD on all tables in a schema. Unless the user is
an authorized, add " and 1 = 2 " should help.

Plus it won't require a lot of changes as well.


That would be a neat way to do it.

Any side effects?

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: