You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!