CODEWITHSUNDEEP
sql-serversql-server-2008
kinkajou
kinkajou

Reputation: 3728

Do we need to provide control permission with select permission to select data?

What does control permission mean in SQL server 2008? When I provide only select permission it does not work i.e. user can't select but when I provide control + select permission then it is possible to select?

Upvotes: 0

Views: 80

Answers (1)

Stephen Turner
Stephen Turner

Reputation: 7314

CONTROL permission gives all other permissions except those explicitly denied. It's almost the same as ownership except that the owner can't be denied a permission.

Control + Select is meaningless, if you have control, then you have select permission anyway.

Upvotes: 1

Related Questions