DSCResources/MSFT_xSQLServerRole/MSFT_xSQLServerRole.schema.mof

 
[ClassVersion("1.0.0.0"), FriendlyName("xSQLServerRole")]
class MSFT_xSQLServerRole : OMI_BaseResource
{
    [Key, Description("The name of the SQL login. If LoginType='WindowsUser' or 'WindowsGroup', this is also the name of the user or group in format DOMAIN\name.")] String Name;
    [Write, Description("Present to ensure that the login has the defined roles, or absent to ensure that these roles are not defined for the login."), ValueMap{"Present","Absent"}, Values{"Present","Absent"}] String Ensure;
    [Required, Description("Type of SQL role to add"), ValueMap{"bulkadmin","dbcreator","diskadmin","processadmin","public","securityadmin","serveradmin","setupadmin","sysadmin"}, Values{"bulkadmin","dbcreator","diskadmin","processadmin","public","securityadmin","serveradmin","setupadmin","sysadmin"}] String ServerRole[];
    [Required, Description("The SQL Server for the login.")] String SQLServer;
    [Key, Description("The SQL instance for the login.")] String SQLInstanceName;
};