-
SQL 7 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 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.
Last edited by ashish9393; 03-19-2003 at 06:01 PM.
-
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.
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
|
|