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

How to get detail of Data Access Security Policies applied at role level using sql query

Summary:

I need to get details of Data Access Security Policies attached at role level. I am using below query to get detail, but it seems its returning data which is entered using "Manage Data Access for User" setup task.

Can some one help me with data table details for Role definitions and DAS policies associated with roles..

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

SELECT pu.username "User Name"
, pr.role_name"Job Role Name"
, role.ACTIVE_FLAG "Is Data Access Active"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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