Friday, 30 January 2009

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.

No comments:

Post a Comment