Repository navigation
SqlRole: Resource refactoring proposal #2172
Description
Resource proposal
A class-based SqlRole resource would manage SQL Server server-level roles and memberships. It would use commands such as Get-SqlDscRole, New-SqlDscRole, Remove-SqlDscRole.
Proposed properties
| Property | Type qualifier | Data type | Description | Default value | Allowed values |
|---|---|---|---|---|---|
| Ensure | Key | String | Whether the role should be Present or Absent | Present | Present, Absent |
| ServerRoleName | Key | String | The name of the server role | None | Any valid server role name |
| Members | Write | String[] | Members of the role | None | Any valid login list |
| ServerName | Key | String | The SQL Server host name | None | Any valid server name |
| InstanceName | Key | String | The SQL Server instance name | None | Any valid instance name |
Special considerations or limitations
Should ensure proper handling of role membership changes, idempotency, and support all built-in and custom roles. Contributors should validate role existence and membership operations.
Activity