VPD column masking
I have about 20 tables, each table has one to a few columns, I don't want all the users to access these columns of these tables.
For example, table TEST1 has column1, column 2, column3, column4 and column5, we have 20 users, 15 users can't access column4 and column5, other 5 users can access all the columns for TEST1, can I use VPD to do this?
Currently, I create a view TEST1_VIEW on test1 for column1, column2 and column3 and allow 15 users to access this veiw only. But is VPD a good way do this?
Thanks