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

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.