Resource Type: dsc_sqldatabasepermission

Defined in:

lib/puppet/type/dsc_sqldatabasepermission.rb

Providers:

powershell

Overview

The DSC SqlDatabasePermission resource type. Automatically generated from ‘SqlServerDsc/DSCResources/MSFT_SqlDatabasePermission/MSFT_SqlDatabasePermission.schema.mof’

To learn more about PowerShell Desired State Configuration, please visit technet.microsoft.com/en-us/library/dn249912.aspx.

For more information about built-in DSC Resources, please visit technet.microsoft.com/en-us/library/dn249921.aspx.

For more information about xDsc Resources, please visit github.com/PowerShell/DscResources.

Properties

• ensure

  The basic property that the resource should be in.

  Supported values:

  • exists?
  • present
  • absent

Parameters

• dsc_database

  Database - The name of the database.

• dsc_ensure

  Ensure - If the values should be present or absent. Valid values are ‘Present’ or ‘Absent’. Valid values are Present, Absent.

• dsc_instancename

  InstanceName - The name of the SQL instance to be configured.

• dsc_name

  Name - The name of the user that should be granted or denied the permission.

• dsc_permissions

  Permissions - The set of permissions for the SQL database.

• dsc_permissionstate

  PermissionState - The state of the permission. Valid values are ‘Grant’ or ‘Deny’. Valid values are Grant, Deny, GrantWithGrant.

• dsc_psdscrunascredential

  PsDscRunAsCredential

• dsc_servername

  ServerName - The host name of the SQL Server to be configured.

• name (namevar)
• provider

  The specific backend to use for this ‘dsc_sqldatabasepermission` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.