NuRoN Consulting, INC.

Blog > SQL Tools > Template Scripts > Users > Get recursive user permissions from multiple databases

Template Script: Users\Get recursive user permissions from multiple databases.sql

SELECT 'Corestore' AS [Database], MemberName, RoleName, UserType, ClassName, Objectname, Permission, StateDesc
FROM Corestore.Metadata.PermissionsRecursive
WHERE MemberName LIKE '%FTLA-GU-CoreStore.Analytics'
UNION ALL
SELECT 'AVM' AS [Database], MemberName, RoleName, UserType, ClassName, Objectname, Permission, StateDesc
FROM AVM.Metadata.PermissionsRecursive
WHERE MemberName LIKE '%FTLA-GU-CoreStore.Analytics'
UNION ALL
SELECT 'ADC' AS [Database], MemberName, RoleName, UserType, ClassName, Objectname, Permission, StateDesc
FROM ADC.Metadata.PermissionsRecursive
WHERE MemberName LIKE '%FTLA-GU-CoreStore.Analytics'
UNION ALL
SELECT 'Temporary' AS [Database], MemberName, RoleName, UserType, ClassName, Objectname, Permission, StateDesc
FROM TEMPORARY.Metadata.PermissionsRecursive
WHERE MemberName LIKE '%FTLA-GU-CoreStore.Analytics'

Description for Template Script: Users\Get recursive user permissions from multiple databases.sql

Todo