tag:blogger.com,1999:blog-3739073232502260520.post2229358814819856925..comments2024-03-19T05:33:41.848-07:00Comments on Dinesh's Blog :::: Being Compiled ::::: Column GRANT overrides DENY Table, Avoiding with Common Criteria ComplianceDinesh Priyankarahttp://www.blogger.com/profile/03528311189201964690noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3739073232502260520.post-4996946097054001622010-05-25T00:57:26.303-07:002010-05-25T00:57:26.303-07:00I cannot think about a real scenario, but my frien...I cannot think about a real scenario, but my friend's environment has such implementation, where user is in a certain group and group has DENIED permission set. In that case, if user needs to be given permission on set of columns, GRANT permission comes in handy. And SQL Server allows to do it!!!<br /><br />So, if you need to remove that facility and stick into the industrial standard (CC), you have to go for the solution given.Dinesh Priyankarahttps://www.blogger.com/profile/03528311189201964690noreply@blogger.comtag:blogger.com,1999:blog-3739073232502260520.post-48491872361799066452010-05-25T00:08:04.842-07:002010-05-25T00:08:04.842-07:00Hi Dinesh
Small Ques.. why should we concern about...Hi Dinesh<br />Small Ques.. why should we concern about the GRANT statement when the user has been DENIED access to the whole table?? is there any reasons???<br /><br />ThanksAvantha Siriwardanahttps://www.blogger.com/profile/17824812624902880403noreply@blogger.com