SqlServerDsc

14.0.0-preview0007

DSCResources/DSC_SqlDatabasePermission/DSC_SqlDatabasePermission.schema.mof

                                [ClassVersion("1.0.0.0"), FriendlyName("SqlDatabasePermission")]

class DSC_SqlDatabasePermission : OMI_BaseResource

{

    [Key, Description("The name of the database.")] String DatabaseName;

    [Key, Description("The name of the user that should be granted or denied the permission.")] String Name;

    [Key, Description("The state of the permission. Valid values are 'Grant' or 'Deny'."), ValueMap{"Grant","Deny","GrantWithGrant"}, Values{"Grant","Deny","GrantWithGrant"}] String PermissionState;

    [Key, Description("The name of the SQL instance to be configured.")] String InstanceName;

    [Required, Description("The set of permissions for the SQL database.")] String Permissions[];

    [Write, Description("If the values should be present or absent. Valid values are 'Present' or 'Absent'."), ValueMap{"Present","Absent"}, Values{"Present","Absent"}] String Ensure;

    [Write, Description("The host name of the SQL Server to be configured. Default value is $env:COMPUTERNAME.")] String ServerName;

};