Resource Type: dsc_sqldatabaseobjectpermission

Defined in:
lib/puppet/type/dsc_sqldatabaseobjectpermission.rb

Overview

The DSC SqlDatabaseObjectPermission resource type. Automatically generated from version 16.6.0

Properties

  • dsc_permission

    Specifies the permissions for the database object and the principal. The permissions is an array of embedded instances of the ‘DSC_DatabaseObjectPermission` CIM class.

  • dsc_servername

    Specifies the host name of the _SQL Server_ to be configured. Default value is the current computer name.

Parameters

  • dsc_databasename (namevar)

    Specifies the name of the database where the object resides.

  • dsc_force

    Specifies that permissions that has parameter Ensure set to ‘’Present’‘ (the default value for permissions) should always be enforced even if that encompasses cascading revocations. An example if the desired state is `’Grant’‘ but the current state is `’GrantWithGrant’‘. If parameter Force is set to `$true` the _With Grant_ permission is revoked, if set to `$false` an exception is thrown since the desired state could not be set. Default is to throw an exception.

  • dsc_instancename (namevar)

    Specifies the name of the _SQL Server_ instance to be configured.

  • dsc_name (namevar)

    Specifies the name of the database user, user-defined database role, or database application role that will have the permission.

  • dsc_objectname (namevar)

    Specifies the name of the database object to set permission for. Can be an empty value when setting permission for a schema.

  • dsc_objecttype (namevar)

    Specifies the type of the database object specified in parameter ObjectName.

  • dsc_psdscrunascredential
  • dsc_schemaname (namevar)

    Specifies the name of the schema for the database object.

  • dsc_timeout

    The maximum time in seconds to wait for the DSC resource to complete.

  • name (namevar)

    Description of the purpose for this resource declaration.

  • validation_mode (defaults to: property)

    Whether to check if the resource is in the desired state by property (default) or using Invoke-DscResource in Test mode (resource).