Add-SqlMonitorAccessRight
Published 29 August 2023
Adds access rights to Principals.
Syntax
Add-SqlMonitorAccessRight -Principals <Principal[]> -MonitoredObjects <MonitoredObject[]> [-Groups <Group[]>] [<CommonParameters>] Add-SqlMonitorAccessRight -Principals <Principal[]> -Groups <Group[]> [<CommonParameters>]
Description
The Add-SqlMonitorAccessRights cmdlet adds access rights to an Principal object.
Connect-SqlMonitor must be called before this cmdlet. Update-SqlMonitorPrincipal should be called to communicate the changes to SQL Monitor.
Parameters
-Principals
<Principal[]>
The principals to grant rights for.
| Aliases | None |
| Required? | true |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | True (ByValue) |
| Accept Wildcard Characters | false |
-Groups
<Group[]>
The groups to grant rights to. At least one of Groups and MonitoredObjects must be specified.
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-MonitoredObjects
<MonitoredObject[]>
The monitored objects (outside specified groups) to grant rights to. At least one of Groups and MonitoredObjects must be specified.
| Aliases | None |
| Required? | true |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-ProgressAction
<ActionPreference>
{{ Fill ProgressAction Description }}
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
-
None.
You cannot pipe input to this cmdlet.
Examples
-------------------------- EXAMPLE 1 --------------------------
$Principals = $Principals | Add-SqlMonitorAccessRight -Groups $Group $Principals | Update-SqlMonitorPrincipal
