I can’t give a Grant in a schema

Asked

Viewed 49 times

0

I am working with an SQL Server 2012 database and I am trying to assign a Grant to a schema with the following command:

GRANT INSERT ON SCHEMA :: trunk TO trunk

And I’m having the following mistake:

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

Does anyone know how I fix?

1 answer

1


Basically what he is telling you is that you are trying to give permissions to a USER who already has such permissions or you are running Grant with the user context you want to give permission to.

That is, you have to make that change with a query to be executed by another user with high permissions.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.