Useful SQL Server security stored procedures

Returns information about the members of a role in the current database.

exec sp_helprolemember

Returns information about user permissions for an object in the current database.

exec sp_helprotect [Table/View/Procedure]

Returns information about the roles in the current database.

exec sp_helprole

For more info check Microsoft MSDN page.

Comments

Popular posts from this blog

Parse XML to dynamic object in C#

C# Crop white space from around the image