Re: oracle data selection
Date: Thu, 24 May 2018 02:11:14 +0700
Message-ID: <CAP50yQ_GfP2yqCjH9BMqCVDQvX=u43_nt5pbr1bxaoE8pVgmcQ_at_mail.gmail.com>
If by superuser you mean SYS - VPD won't work. SYS bypasses VPD policies.
I believe that your only option is Oracle Database Vault (which is an extra
cost option).
Stefan
On Thu, May 24, 2018 at 1:50 AM, Steve Harville <steve.harville_at_gmail.com>
wrote:
> You can use VPD (virtual private database)
>
> On Wed, May 23, 2018 at 1:38 PM Nagaraj chk <nagaraj.chk_at_gmail.com> wrote:
>
>> Hi Gurus,
>>
>> I have a requirement to hide particular columns during select even as an
>> super user, However i should able to do explain plan on those tables.
>> Please guide me if this is possible using data masking or any other options
>> available ?
>>
>> -Naga
>>
>
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 23 2018 - 21:11:14 CEST