Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

edited Jul 15, 2019 11:10AM in Reporting and Analytics for ERP 16 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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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