I have a stored procedure to restore the latest backup of a prod database to an acceptance database. Once it's restored I need to grant a user read access to the database.
Use statements are not allowed in stored procedures, and both
ALTER ROLE (it's a SQL Server 2012 box) and
sp_addrolemember don't take a target database parameter.