Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does Oracle Have Anything Similar to SqlServer "Deny" Attribute?

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

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 19 Apr 2007 16:41:23 -0700
Message-ID: <bf46380704191641kc41ddf9ob3e96b589169498c@mail.gmail.com>


On 4/19/07, rjamya <rjamya_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 19 2007 - 18:41:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US