Security on each object

SELECT  Distinct
SecurityObjInstances.InstanceKey AS ‘object’,
SecurityObjInstances.UserName,
vSecurityClassPermissions.PermissionName
FROM  SecurityObjInstances SecurityObjInstances,
vSecurityClassPermissions vSecurityClassPermissions
WHERE  vSecurityClassPermissions.ObjectKey = SecurityObjInstances.ObjectKey
AND vSecurityClassPermissions.UserName = SecurityObjInstances.UserName
ORDER BY
SecurityObjInstances.InstanceKey,
SecurityObjInstances.UserName,
vSecurityClassPermissions.PermissionName

 

Leave a Reply

Your email address will not be published. Required fields are marked *