From: SQL Servant on
Is it possible to change the list of reports a user can access through stored
procedures? At the moment I run a stored procedure to get a list of all
reports a user has access to but then change permissions manually as I don't
have a definitive list of all relevant SQL Server tables.

SQL Servant