Test-SqlMonitorMonitoredObjectAccess
Published 13 January 2021
Tests if a principal has access to a given cluster, non-clustered machine, Azure SQL Database, etc.
Syntax
Test-SqlMonitorMonitoredObjectAccess [-Principal] <ADPrincipal> [-Object] <MonitoredObject> [<CommonParameters>]
Description
The Test-SqlMonitorMonitoredObjectAccess cmdlet checks the authorizations for a principal to work out if it has access to a monitored entity.
Connect-SqlMonitor must be called before this cmdlet.
Parameters
-Principal
<ADPrincipal>
The Name of the AD Principal to check access for.
| Aliases | None |
| Required? | true |
| Position? | 1 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-Object
<MonitoredObject>
The monitored object to test access to.
| Aliases | None |
| Required? | true |
| Position? | 2 |
| 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.
Return values
The output type is the type of the objects that the cmdlet emits.
-
None.
You cannot pipe input to this cmdlet.
Examples
-------------------------- EXAMPLE 1 --------------------------
$Report = Test-SqlMonitorMonitoredObjectAccess -Principal $Principal -MonitoredObject $Machine
