Permissions while deleting rows from a table

Question

I have a table with rows having duplicate userId's. I am trying to delete the row's as

delete from table_name where userId=123

This query works only if I give both select and delete permissions to the database. Is is compulsory to grant the select permission?

Answer 1

DELETE permissions are required on the target table. SELECT permissions are also required if the statement contains a WHERE clause. Here is link from microsoft, refer permission section

http://msdn.microsoft.com/en-us/library/ms189835.aspx