I accidentally removed
SELECT and other permissions from my user on SQL Server 2014 via Properties.
I checked all the permissions except the Guest in the Owned Schemas list and also in Membership - including
db_denydatawriter. That's what made me this mistake. There are some permissions (
db_denydatawriter) that if you check them, you would remove your own permission without being able to regrant them. I checked all of them.
Cannot alter the role 'sp_denydatareader', because it does not exist or you do not have permission.
Unfortunately I can't use
SELECT and other function on my queries or selecting the Properties again in order to uncheck the permissions.
What should I do? I'm not the admin on the box. Is there any way to restore it without asking the sysadmin?