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 [...]