Get users permissions with mapping thru role.

By James Travis, 2013/05/22

This procedure is similar to sp_helpprotect except to extends a bit on the concept with roles involved. If for instance a user has right on a TableX but they are not mapped directly to the user but instead to a role then sp_helpprotect does not tell you this. This will tell you how the user inherites a right from a role and all is in a crosstab format. This is still a work in progress and, yes I know you could accomplish thru sp_helprotect and sp_helprolemember in combination but that is not how I wanted to put this together.

Total article views: 1548 | Views in the last 30 days: 2

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Get users permissions with mapping thru role.

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: