Home Forums SQL Server 2005 T-SQL (SS2K5) How to get user roles RE: How to get user roles
vikingDBA
SSCertifiable
Points: 5356
More actions
April 5, 2013 at 2:33 pm
#1604136
Oops.. As far as permissions, I put it in a SPROC and set the WITH EXECUTE AS OWNER clause to the CREATE PROCEDURE statement and made the owner dbo.
Then gave all database users that needed it the access to run the SPROC.