SQL db_reader database membership

Last post 08-28-2008 11:32 AM by cparker. 6 replies.
Page 1 of 1 (7 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 08-27-2008 3:01 PM

    SQL db_reader database membership

    In the Login properties of one of our reports in the User Mapping page we have a user called copump. Every couple of days, the db_datareader role turns off. What can I do to keep this account from losing membership in theis role?
  • 08-28-2008 1:29 AM In reply to

    Re: SQL db_reader database membership

    Do you have Scheuled restore of the database from any other environment..

    Cheers,
    Prabhakar
  • 08-28-2008 7:16 AM In reply to

    Re: SQL db_reader database membership

     Not that I am aware of. Wouldn't that erase any data input into the database? How can I check that?

  • 08-28-2008 8:06 AM In reply to

    Re: SQL db_reader database membership

    Check the system table restorehistory on msdb database

    Cheers,
    Prabhakar
  • 08-28-2008 9:41 AM In reply to

    Re: SQL db_reader database membership

     Is there anyway to lock that role to keep it from being removed regardless of restoring?

  • 08-28-2008 9:51 AM In reply to

    Re: SQL db_reader database membership

    No, you can't...You shd add the user after each restore

    Cheers,
    Prabhakar
  • 08-28-2008 11:32 AM In reply to

    Re: SQL db_reader database membership

     It isn't a restore, is there some way I can audit what is making the changes?

Page 1 of 1 (7 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.