Skip to content

Instantly share code, notes, and snippets.

@DarkAllien

DarkAllien/AppInfo.sql

Created October 23, 2018 10:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DarkAllien/60e8ac4e179ce32a7f9514b027092a60 to your computer and use it in GitHub Desktop.
Save DarkAllien/60e8ac4e179ce32a7f9514b027092a60 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AppInfo.sql
SELECT DISTINCT
[aa].[ApplicationName]
FROM [v_ApplicationAssignment] [aa]
ORDER BY 1;
@ErshovIS
Copy link

You could also use RBAC function to get user-specific Applications

select distinct ApplicationName
from [dbo].[fn_rbac_ApplicationAssignment](@UserSIDs)
ORDER BY 1;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment