Post reply

Corrupt Public role

  • December 9, 2004 at 7:06 pm

    #162862

    I have a production system where I have a user who has the roles Public and datareader. Up until yesterday they were able to connect to the system Now they cant and it seems that even though they have the public role they dont have the select privlages on the  master, msdb and temp dbs so they are blocked form connecting to the system.

    I have gotten around this by granting the user readonly on the table in those db's needed to connect. My question is how would the public role become corrupt and how can I recover it.

     

    Thanks...

     

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • December 13, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • December 16, 2004 at 12:12 pm

    #534213

    Take a look at the default database for this user.  If the default database no longer exists, or if the default database is offline or otherwise not accessible, SQL Server will connect the user to the master database.  If the user has no permissions in the master database as normally they wouldn't, they will not be able to do anything once connected.  I suspect you need to change the default database for this user.

     

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

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