SQL Server 2008 – Retrieving a Usersโ€™ Privileges for all tables in a databse

I recently answered a question on StackOverflow.com by a user who needed to retrieve a list of a given users Privileges for each Table in a given Database.After some trial an error I ended up with the following T-SQL Script; declare @Proc nvarchar(50)declare @RowCnt intdeclare @MaxRows intdeclare @ExecSql nvarchar(255)ย select @RowCnt = 1select @Proc = 'SELECT [...]

By |2017-07-24T08:33:18+01:00January 21st, 2013|Data, SQL Server, T-SQL|0 Comments