0

I am trying to add a stored procedure to the master database (I deliberately am trying this for the master db) on Azure SQL. Is this possible? I suspect the answer is "no", but I'd like to see some confirming documentation on it if that is the case.

What I've tried so far:

Here's the procedure (just as a test):

CREATE PROCEDURE dbo.blah AS RETURN 0;

I've tried the above using the admin login, and it failed:

Msg 262, Level 14, State 18, Procedure blah, Line 2 [Batch Start Line 21]
CREATE PROCEDURE permission denied in database 'master'.

I then tried to create another login and user and then assigned them to the "dbmanager" role and tried the create procedure again - same failure.

0

Not if you are using Azure DB. Probably if you use Azure Instance.

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server#security

1
  • Could you quote the section that is pertaining to my issue? I looked through it and didn't see anything that looked relevant to the question. – Anssssss Apr 20 at 20:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.