Which table stores the delegated developer access?

[Javed1]

Does anyone know which table stores the delegated developer access? I know the table sys_user_has_role shows who has the role but I know to see who has access to which application. Is that something we have access to?

Thanks 

[OlaN · Accepted solution]

Hi,

Dug into this out of curiosity, and I found the following.

The table sys_scope_permission_set_role_assignment contains all permission records created on your various scoped apps.

When a user is granted access, as delegated development a role (sys_user_role) is created with a naming convention as follows sn_dd_scopeapplicationname_permissionname

And finally the user is added as a member of the newly created role.

Hopefully this will help you.

[Javed1]

Thanks!! This is what I was after.