Examples/Resources/xSQLServerDatabaseOwner/1-SetDatabaseOwner.ps1
|
<# .EXAMPLE This example shows how to ensure that the user account CONTOSO\SQLAdmin is "Owner" of SQL database "AdventureWorks". #> Configuration Example { param ( [Parameter(Mandatory = $true)] [System.Management.Automation.PSCredential] [System.Management.Automation.Credential()] $SysAdminAccount ) Import-DscResource -ModuleName xSqlServer node localhost { xSQLServerLogin Add_SqlServerLogin_SQLAdmin { Ensure = 'Present' Name = 'CONTOSO\SQLAdmin' LoginType = 'WindowsUser' SQLServer = 'SQLServer' SQLInstanceName = 'DSC' PsDscRunAsCredential = $SysAdminAccount } xSQLServerDatabaseOwner Set_SqlDatabaseOwner_SQLAdmin { Name = 'CONTOSO\SQLAdmin' Database = 'AdventureWorks' SQLServer = 'SQLServer' SQLInstanceName = 'DSC' PsDscRunAsCredential = $SysAdminAccount } } } |