Previous Version

This is a previous version of the Ed-Fi ODS / API. Visit the Ed-Fi Tech Docs home page for a link to the current version, or the Ed-Fi Technology Version Index for links to all versions.

The SQL queries on this page enable a database administrator to view information about security configurations. Execute the queries from the EdFi_Security database.

View Permissions Under a Claim Set

USE EdFi_Security
GO

SELECT ClaimSets.ClaimSetName, ResourceClaims.DisplayName, Actions.ActionName
FROM ClaimSets
JOIN ClaimSetResourceClaims ON ClaimSetResourceClaims.ClaimSet_ClaimSetId = ClaimSets.ClaimSetId
JOIN ResourceClaims ON ResourceClaims.ResourceClaimId = ClaimSetResourceClaims.ResourceClaim_ResourceClaimId
JOIN Actions ON Actions.ActionId = ClaimSetResourceClaims.Action_ActionId

View Configured Authorization Strategies per Resource Claim

USE EdFi_Security
GO

SELECT Actions.ActionName, AuthorizationStrategies.DisplayName AS AuthorizationName, ResourceClaims.ResourceName
FROM  ResourceClaimAuthorizationStrategies
JOIN ResourceClaims ON ResourceClaims.ResourceClaimId = ResourceClaim_ResourceClaimId
JOIN Actions ON Actions.ActionId = ResourceClaimAuthorizationStrategies.Action_ActionId
JOIN AuthorizationStrategies ON AuthorizationStrategies.AuthorizationStrategyId = AuthorizationStrategy_AuthorizationStrategyId
ORDER BY ResourceClaim_ResourceClaimId

View Applications in Claim Sets

USE EdFi_Security
GO

SELECT Apps.ApplicationName, Apps.ClaimSetName
FROM ClaimSets
JOIN EdFi_Admin.dbo.Applications Apps ON Apps.ClaimSetName = ClaimSets.ClaimSetName