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

SQL script for Roles , Privileges, Inherit roles & Data Security Policies

Accepted answer
201
Views
11
Comments
edited Jul 15, 2019 11:10AM in Reporting and Analytics for ERP 11 comments

Summary

SQL script for Roles , Privileges, Inherit roles & Data Security Policies

Content

Trying to built a query to fetch Application Roles, Privileges, Data Security & Role Hierarchies, where i am able to get roles and their privileges but could not able to fetch the data security policies & roles inherited.

I have tried using the application security tables ASE_ROLES_V, ASE_ROLE_ROLE_MBR, ASE_PRIV_ROLE_MBR, ASE_PRIVILEGE_VL, also not able to view data from data model.

 

regards,

Amar.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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