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

*or*

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?  :)
Posted by at
Labels: , ,

3 comments:

  1. David SvatoraOctober 19, 2012 at 12:54 PM

    Too much access...

    ReplyDelete
  2. AnonymousOctober 19, 2012 at 1:26 PM

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

    ReplyDelete
  3. AnonymousOctober 19, 2012 at 9:43 PM

    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.

    ReplyDelete

Subscribe to: Post Comments (Atom)