Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Unanswered: Adding users in db_datareader on Snapshot db

    Here is my mirroring setup

    Server1 -> Principal
    Server2 -> Mirror

    the database being mirrored is "mydb"

    there is a scheduled job to create the db snapshot the snapshot db name is mydb_SNAP

    now the requirment is to create a set of users (user1, user2.. userN) who has db_datareader role in mydb_SNAP.

    how can this be done?
    Cheers....

    baburajv

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    you need to create those users on the Principal server, then the next snapshot will have them.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •