1

When trying to run the following to create a Server Role, I get permission error shown below. But I can successfully create the same role using SSMS. Question: Why?

CREATE SERVER ROLE TestRole AUTHORIZATION [dbo];

Error: Msg 15151, Level 16, State 1 Cannot find the server principal 'dbo', because it does not exist or you do not have permission.

asked Apr 21, 2023 at 15:17

1 Answer 1

1

A server role is a server level securable. Because of that it is owned by a login, not a user. Dbo is a user. Either remove the authorization clause or specify a relevant login as the owner.

answered Apr 21, 2023 at 18:17

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.