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;
};