Controleer schema permissions database user

PHOTO EMBED

Thu Feb 29 2024 10:39:48 GMT+0000 (Coordinated Universal Time)

Saved by @merol007

 SELECT state_desc
    ,permission_name
    ,'ON'
    ,class_desc
    ,SCHEMA_NAME(major_id)
    ,'TO'
    ,USER_NAME(grantee_principal_id)
FROM sys.database_permissions AS PERM
JOIN sys.database_principals AS Prin
    ON PERM.grantee_principal_id  = Prin.principal_id
        AND class_desc = 'SCHEMA'
content_copyCOPY