I have a task that requires me to do the following (running Oracle 10.2.0.3)
Allow a limited number of users select privilige from a number of tables and mask the data in certain columns where they cannot see the data. I understand that this can be done using VPD.
I have never used this tool. Does anyone have an example of how I would implement something like this for certain users and give me some insight on how to maintain it as i add or remove users from this priviledge? It could be as many as 10 users and as many as 100 tables affected.
Is there another suggestion/example on how I would do this.