-
user table rights
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.
Last edited by ashish9393; 03-19-2003 at 05:04 PM.
-
Just put red x in delete box for user or group in em, or use remoke command in query analyzer.
-
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.
-
Does user belong to sysadmin server role? Tried revoke command?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|