Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2010-10-04 : 08:51:39
|
| I need to deny any delete operation for a dbadmin user. I've created a new user with same roles as sa. On database name->Properties->Permissions window I've clicked Deny for Delete permission for this new user. I logged in to SQL Management Studio with this user and ran a delete tsql and it successfully deleted the record. What am I missing ot doing wrong? Does the db_owner role overwrite denies? What should I do to create a user with the same permissions as sa but without delete?The server is SQL Server 2005 standart. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-10-04 : 11:56:05
|
| If the login is in the sysadmin role, you cannot prevent them from deleting data.CODO ERGO SUM |
 |
|
|
|
|
|
Deny permission for a user