grant revoke delete truncate update drop statement

grant select on schema.table to &user;

revoke select on schema.table from &user;

delete schema.table where column='&column_name';

truncate table schema.table;

update schema.table set &column_name=&value where &column_name=&value;