SQL 7 user table rights

[ashish9393]

Hi,
I have 2 databases which were setup simultaneously, dev & prod.

In dev I have removed user rights to delete any rows. It works great. I went in the enterprise manager and selected a particular table, right click > All tasks > Manage permissions and then removed the delete permission,

When I do the same thing in prod, it doesn't work.
What am I doing wrong ? Are there some settings that override these table permissions ?

Please bear with me, I have barely worked with SQL server and this is a production system where i need to remove delete rights.

thanks in advance.
Ash.

[skhanal]

Users may have delete rights through their membership in a user defined role or database fixed roles (such as db_writer, db_owner, etc) or fixed server role (such as sysadmin)

Make sure that the user is not in any of these roles.