Post reply

DBCC CHECKDB changed login permissions

  • December 16, 2009 at 9:19 am

    #137650

    After running a DBCC CHECKDB, one login missed its DBOWNER permission to its DB.

    There was a DB having consistency error (which I fixed later), but the DB is not the one which the login missed the DBOWNER for.

    By missing, it means the login had the DBO permission before the DBCC run but not after.

    Anyone ever had this before or could you help me to figure out how this could happen?

    TIA.

  • December 16, 2009 at 9:36 am

    #1093131

    I'm going to hazard a guess that it's a coincidence.

    Or did you have to do anything to the master database?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply