Hiding column
User1 and User2 has SELECT privileges on UserApp tables whereby the privileges were granted through the use of Database Vault.
apptable contains 5 columns, i.e. ID, DETAILS, SECURE1, SECURE2, REMARKS.
-- Is it possible to hide some columns from User1 when User1 issues a SELECT * FROM apptable? User1 should only see colums ID, DETAILS, REMARKS whereas User2 can see all 5 columns.
Have considered VPD and OLS but they are not relevant in this case as I understand that it restricts which user can see which rows. There is no row restriction imposed for User1 and User2.