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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DENY DELETE

Author  Topic 

Fred_Scuttle
Starting Member

13 Posts

Posted - 2005-11-15 : 00:03:10
Hello,
Is is possible to Grant a 'DENY DELETE' on a table to the 'sa'user or will the fact that he is administrator over ride the restriction.

Thanks

Fred Scuttle

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-11-15 : 01:04:25
Fact he is user overrides. Even if it didn't, he could just change it. lol

Why would you want to do this???

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Fred_Scuttle
Starting Member

13 Posts

Posted - 2005-11-15 : 02:15:09
Point taken, thanks;-)
Go to Top of Page
   

- Advertisement -