Hey can anyone help me in writing script that how we can deny permission on mutilple objects at once suppose there is a user A and we want to deny permission for update,delete from every table in the database. do you have nay idea please i tried: declare @user varchar(100) set @user = 'A' DENY 'SELECT, INSERT, UPDATE, DELETE' on '[' + table_schema + '].[' + table_name + ']'to @user = 'A' go this didnot worked can you help please thanks a lot