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
