Forum Replies Created

Viewing post 1 (of 1 total)

  • Reply To: Script out permissions - Azure SQL database

    Hey SQL!@w$0M,

    I use this script to generate a Matrix of the rights on a database:

    DECLARE @permissionlevels TABLE
    (
    PermissionLevel NVARCHAR(256)
    )

    INSERT INTO @permissionlevels
    SELECT DISTINCT pp.name AS PermissionLevel
    FROM sys.database_role_members roles
    LEFT JOIN...

Viewing post 1 (of 1 total)