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 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.

[rmiao]

Just put red x in delete box for user or group in em, or use remoke command in query analyzer.

[ashish9393]

Originally posted by rmiao
Just put red x in delete box for user or group in em, or use remoke command in query analyzer.

Thats what I have done for both dev & prod. But it only works with dev.
I have put the red X in both the user & its group.

thanks.

[rmiao]

Does user belong to sysadmin server role? Tried revoke command?