Hello, I checked the manuals and just wanted to confirm if my understanding is right.
My user wants to provide Select table access to certain users but restrict (prevent) access to certain rows (identifiable by key).
The Managing Security manual notes that views may be problematic for Insert, Update and Delete. In my case, only Select is involved.
And the other issue mentioned in the manual of accountability or auditability of access of those restricted rows is, I believe, not an issue for my user (awaiting confirmation).
If my user confirms this, is there any reason to go with Multilevel Security and the set up involved (RACF and security labels and populating them appropriately, etc.)? I am thinking the KISS principle might apply.
Thanks in advance.