RDBMS: SQL Server 2005
I am connecting to SQL Server through Windows Authentication. My account(domain\me) belong to a group, "domain\alert"
The problem is that, even after denying a select permission on a table(actually all permissions), I could still access that table on a new connection.
deny select on dbo.perm to [domain\me]
GO
And one thing to note is that, the group i belong to, "domain\alert" is a dbo of database the table is located.
As far as I know, deny
permission takes precedence over grant
.
What permission can still be granting me a permission to select
the perm
table?