This version of the Ed-Fi ODS / API is no longer supported. See the Ed-Fi Technology Version Index for a link to the latest version.

 

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Current »

The Security Visualization Tool is a command-line utility to view and graphically depict security configurations. However, it is sometimes useful to view configurations as stored in the system. 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

 

  • No labels