Execute Permissions for a Store Procedure that creates databases
4
votes
1
answer
1216
views
I have a Stored Procedure that creates a Database for a specific project which needs to run every month by one of our Data Analysts. The question is how do I structure this to enable the Analyst to run this Stored Procedure without granting them Create Database Permission.
I Tried
WITH EXECUTE AS OWNER/USER_NAME
The Analysts still get the below error:
Msg 262, Level 14, State 1, Line 67
CREATE DATABASE permission denied in database 'master'.
Any advice?
Asked by JPVoogt
(223 rep)
May 21, 2019, 11:24 AM
Last activity: May 24, 2019, 05:38 AM
Last activity: May 24, 2019, 05:38 AM