Re: oracle data selection

Thanks Vishnu. invisible column feature really helps my requirement.

-Naga

On Thu, May 24, 2018 at 1:03 AM, Vishnu <vishnukumarmp_at_gmail.com> wrote:

> Naga - If you are in 12c, you can try using invisible columns. It wont
> show the column even if you are a super user or owner of the object, you
> can still do explain plan on those tables. you need to explicitly specify
> the column name to read it. But i'm not sure whether this will satisfy all
> of your requirements.
>
> Thanks,
> Vishnu
>
> On Wed, May 23, 2018 at 3:11 PM, Stefan Knecht <knecht.stefan_at_gmail.com>
> wrote:
>
>> 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