ASE_USER_ROLE_MBR table usage restriction and alternate table suggestion
Summary:
Is ASE_USER_ROLE_MBR not supposed to be used for BI reporting? If yes, what is the reason, and what could be the alternate way to get the role revocation details
Content (please ensure you mask any confidential information):
I want to develop an audit report to capture user role assigned and ended, data access set assigned and revoked details, along with the "who" column. I have already tried using the PER_USER_ROLES and FUN_USER_ROLE_DATA_ASGNMNTS tables. Both the tables have the problem that when the access is revoked, then that information is not captured (the End_date field is not updated). Can anyone please suggest to me alternate tables or queries to fulfill this requirement?
Tagged:
0