Message:
Cannot grant deny or revoke permissions to sa dbo entity owner information_schema sys or yourself.
This message occurs when yoy try to revoke permissions for the following users:
– yourself
– sa
– dbo
– entity owner
– information_schema
– sys
Resolution:
If you wanted to grant/revoke (or) deny permissions for yourself instead of running the query using yor own login
You can alternatively
– Login as a different user and run the query.
– Ask another SQL Server user to grant/revoke (or) deny permissions to you.
– Ask your DBA to grant/revoke (or) deny permissions.