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