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

Reporting Variance - Security Console vs Security Detail Extract

Received Response
21
Views
1
Comments
edited Mar 12, 2024 1:08PM in Applications Security 1 comment

We would like to understand the source of truth for user roles and privileges. We have a report that is looping through the ASE_ROLE_ROLE_MBR table linking the child and parents roles, then looking up those roles in ase_priv_role_mbr to retrieve the role privileges. The report is returning the same roles as the Security Console, but the privileges differ.

Should the ASE_ROLE_ROLE_MBR table and the Security Console match? Please advise.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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