I can not give a grant in a schema

Navigation
0

I'm working with a SQL Server 2012 database and I'm 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 error: 

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

Does anyone know how to solve it?

    
asked by anonymous 23.09.2015 / 19:48

1 answer

1

In the background what he is telling you is that you are trying to give permissions to a USER who already has these permissions or you are running the grant with the context of the user you want to give permission.

In other words, you have to make this change with a query to be executed by another user with high permissions.

    
13.10.2015 / 20:23
Factory of objects related to local persistence in Swift day counting system in php