Skip to content
No description, website, or topics provided.
Branch: master
Clone or download
Latest commit 7f10416 Nov 15, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md Initial commit Nov 15, 2018
sp_help_permissions.sql

README.md

sp_help_permissions

Copyright Daniel Hutmacher under Creative Commons 4.0 license with attribution.

Source: http://sqlsunday.com/downloads/

WHAT: This script lists all permissions by principal, securable and permission. Optionally, you can filter these objects using the @principal, @securable, and/or @permission parameters (using T-SQL wildcards).

The output can be tabular with permissions grouped as comma-separated lists (using @permission_list=1) or one row for each permission (@permission_list=0). You can also return the result as an xml OUTPUT variable, using @output_xml=1 and collecting the output from the @xml parameter.

VERSION: 2017-10-06

DISCLAIMER: This script does not make any modifications to the database apart from installing and registering a stored procedure in the master database, but may still not be suitable to run in a production environment. I cannot assume any responsibility with regards to the accuracy of the output information, any performance impact on your server, or any other consequence. It's free software, so you assume responsibility. If your juristiction does not allow for this kind of waiver/disclaimer, or if you do not accept these terms, you are NOT allowed to store, distribute or use this code in any manner.

You can’t perform that action at this time.