VPD scope : (DBMS_RLS)
Hi, I am going to implement new security policy in database for some users so they couldnt see some confidential data in tables using VPD.
I studied about VPD and found that first we need to create function and then using DBMS_RLS package add policy for tables.
Now if we run any query then returned predicate bu function is added in "where clause" of the query.
Here my query ::
Is this possible in VDP to build the function so in query result we can ommit some columns??
say my table XXXX has 3 columns (name, mob,creditcard)
so whenever I execute select * from XXXX; I view only name and mob. and creditcard value is diplayed as xxxxxxxxx.
Thanks