SQL to return all row level security assigned to an OPRID
Campus Solutions 9.2, PT8.59
---------------------------------
Has anyone else come across the need to find out what row-level security tables that an OPRID has by querying the database? I'm interested in those only under Set Up SACR - Security - Secure Student Administration - User ID.
At this stage I want to return the OPRID and the RECNAME of the database table, if that OPRID has an entry in it - e.g.
xyz123 | SCRTY_TBL_INST
xyz123 | SCRTY_TBL_CAR
This way I would know that OPRID xyz123 has entries in both the Institution and Career row-level tables.
I'm wondering how the hive mind would approach it if ever asked to do this. I can write a View which hard codes each table into the logic, but wondering if there's a better (or even a delivered) way.