Thanks Vishnu. invisible column feature really helps my requirement.
-Naga
On Thu, May 24, 2018 at 1:03 AM, Vishnu <vishnukumarmp@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx
wrote:
You can use VPD (virtual private database)
On Wed, May 23, 2018 at 1:38 PM Nagaraj chk <nagaraj.chk@xxxxxxxxx>
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 | @zztat_oracle | fb.me/zztat | zztat.net/blog/
