LabinaBox

1.0

DSCResources/xSQLServer/2.0.0.0/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;

};