forked from dsccommunity/SqlServerDsc
-
Notifications
You must be signed in to change notification settings - Fork 0
/
3-EnforceDatabaseRoleMembers.ps1
33 lines (29 loc) · 1019 Bytes
/
3-EnforceDatabaseRoleMembers.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<#
.EXAMPLE
This example shows how to do the following:
1. Ensure that the database role named ReportViewer is present in the AdventureWorks database on instance
sqltest.company.local\DSC
2. Ensure that users CONTOSO\Barbara and CONTOSO\Fred will always be the only members of the role
#>
Configuration Example
{
param(
[Parameter(Mandatory = $true)]
[System.Management.Automation.PSCredential]
$SqlAdministratorCredential
)
Import-DscResource -ModuleName SqlServerDsc
node localhost
{
SqlDatabaseRole ReportViewer_EnforceRoleMembers
{
ServerName = 'sqltest.company.local'
InstanceName = 'DSC'
Database = 'AdventureWorks'
Name = 'ReportViewer'
Members = @('CONTOSO\Barbara', 'CONTOSO\Fred')
Ensure = 'Present'
PsDscRunAsCredential = $SqlAdministratorCredential
}
}
}