SQL SERVER 2016. I have a user that I want to grant all privileges on all database tables except for DROP, TRUNCATE, DELETE, INSERT, UPDATE. The Database has over 300 tables and I can’t do this one by one. I need something like:
REVOKE DROP, TRUNCATE, DELETE, UPDATE, INSERT ON DATABASENAME.* FROM USER1;
But its throwing an error when I put the DATABASE.* with * representing all tables.