User does not have permission to perform this action.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

It seems you do not have the permissions to add a new member to the db_owner role (which is the most priviliged role on the database level).

Are you an administrator?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

venkidesaik Right there with Babe Points: 785 More actions · Answer 2

Thanks for replying Koen Verbeeck.

Am not the admin.

if the user is not the admin then how to resolve this issue?

is there any other way?

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

There's maybe a reason why you cannot do this: you are not the admin.

Granting members to the db_owner rule is making them admin on that database.

If you want to do this, you need to ask the administrator of the server to give you the necessary permissions.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP