1

I have a user which is added to a role xyz and this role has been assigned some permissions like data read/write, execute etc on a database.

While executing a select query on a column of a table it displays an error

The select permission was denied on the column ...

I could see while taking the properties of the table that that role has been granted as select to all the columns in that table.

Can anyone point me to what I'm missing?

Improve this question
3
  • Is that a table or a view? It might be a view selecting a subset of columns from the underlying table.
    – Vikdor
    Commented Feb 6, 2014 at 5:06
  • @Vikdor: It is definitely a column under dbo.table
    – Vysakh
    Commented Feb 6, 2014 at 6:06
  • DENY trumps GRANT. Look in sys.database_permissions for any DENY permissions. major_id = object_id of the table, minor_id = column_id. But look for any DENY permissions; they assert themselves in non-obvious ways sometimes.
    – Ben Thul
    Commented Feb 6, 2014 at 11:33

1 Answer 1

Reset to default
1

I have found out the solution. This specific user was added to another role in which "Deny" permissions was set against these tables. Removing that permission solved my issue...

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.