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
 SQL Server 2012 Forums
 Transact-SQL (2012)
 DENY vs unchecking the permission boxes?

Author  Topic 

bulump
Starting Member

6 Posts

Posted - 2013-03-26 : 17:21:09
Sorry for the noob question, but for some reason I can't come up with the appropriate answer.

What's the difference between DENYing, say EXECUTE, on sp_addlogin versus unchecking the permission check boxes within the Securable dialog of the GUI?

chadmat
The Chadinator

1974 Posts

Posted - 2013-03-26 : 17:27:57
Someone might have a permission that they derive from a group or role, you don't want to take that permission from the entire group, you can deny for just the one person.

-Chad
Go to Top of Page
   

- Advertisement -