One DBA's Ongoing Search for Clarity in the Middle of Nowhere


Yet Another Andy Writing About SQL Server

Friday, October 19, 2012

A Minor Problem of Access

A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't do anything:

Can you spot the problem?  :)


  1. db_ViewProcedures, that doesn't sound like a normal role ;)

  2. I would have said that the problem is that they have db_denydatareader and db_denydatawriter, however I would have thought db_owner would have overridden that. My understanding is that DENY always overrides GRANT except in the case of sysadmin or db_owner. I could be wrong about db_owner though.