Unanswered: Row level Security in DB2 UDB v8.1 + Linux
Is it possible to implement row level security in DB2 UDB v8.1 and linux on a table for different users. The requirement is that a user should be able to see and update the rows belonging to his User ID only. One way to do is views. However, i want to know if we can somehow achieve it through Special registers like USER. Please help
AFIAK, this feature is not available in this release of db2 ...
I understand that this feature is not available in db2. However, can we take an indirect approach to implement it at the basic level. Something like, if we can figure out which user is logged in and then attach some security tag to the user name which can further be placed on the table. and then we can match the security tags. Please let me know if this can work.