xSQLServer

5.0.0.0

Examples/Resources/xSQLServerDatabasePermission/2-RevokeDatabasePermissions.ps1

                                <#

.DESCRIPTION

    This example shows how to ensure that the user account CONTOSO\SQLAdmin

    hasn't "Select" and "Create Table" SQL Permissions for database "AdventureWorks". 

#>

Configuration Example 

{

    param(

        [Parameter(Mandatory = $true)]

        [PSCredential]

        $SysAdminAccount

    )

    Import-DscResource -ModuleName xSqlServer

    node localhost {

        xSQLServerDatabasePermission RevokeGrant_SqlDatabasePermissions_SQLAdmin

        {

            Ensure = 'Absent'

            Name = 'CONTOSO\SQLAdmin'

            Database = 'AdventureWorks'

            PermissionState = 'Grant'

            Permissions = 'Connect','Update'

            SQLServer = 'SQLServer'

            SQLInstanceName = 'DSC'

            PsDscRunAsCredential = $SysAdminAccount

        }

        xSQLServerDatabasePermission RevokeDeny_SqlDatabasePermissions_SQLAdmin

        {

            Ensure = 'Absent'

            Name = 'CONTOSO\SQLAdmin'

            Database = 'AdventureWorks'

            PermissionState = 'Deny'

            Permissions = 'Select','Create Table'

            SQLServer = 'SQLServer'

            SQLInstanceName = 'DSC'

            PsDscRunAsCredential = $SysAdminAccount

        }

    }

}