< Back
Test-CurrentPermissions
Post
NAME Test-CurrentPermissions
SYNOPSIS
Test permissions of current user to verify that htey have the correct permissions to execute deployment.
SYNTAX
Test-CurrentPermissions [-sqlConnection] <SqlConnection> [<CommonParameters>]
DESCRIPTION
Check that the account running the deployment has the correct permissions to successfully execute a deployment.
If an account is sysadmin then this is very straightforward.
If account is not sysadmin then we check that the minimal permissions have been granted. Consult the readme for
list of permisions, or view the SQLbelow.
Currently the check permissions on the proxy is deactivated. This will be added at a later date.
PARAMETERS
-sqlConnection <SqlConnection>
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Test-CurrentPermissions -SqlServer $SqlSvr
RELATED LINKS
SYNOPSIS
Test permissions of current user to verify that htey have the correct permissions to execute deployment.
SYNTAX
Test-CurrentPermissions [-sqlConnection] <SqlConnection> [<CommonParameters>]
DESCRIPTION
Check that the account running the deployment has the correct permissions to successfully execute a deployment.
If an account is sysadmin then this is very straightforward.
If account is not sysadmin then we check that the minimal permissions have been granted. Consult the readme for
list of permisions, or view the SQLbelow.
Currently the check permissions on the proxy is deactivated. This will be added at a later date.
PARAMETERS
-sqlConnection <SqlConnection>
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Test-CurrentPermissions -SqlServer $SqlSvr
RELATED LINKS