Home Forums Article Discussions Article Discussions by Author Discuss content posted by william thier Configuring Database Mirroring RE: Configuring Database Mirroring

  • February 1, 2011 at 4:39 am

    #1280850

    sireesha.budagala (2/1/2011)

    How Can we modify the Login permissions on SQL Mirrored Database ?

    for ex : 'abc' is the Login we need to reduce the level of permission from 'db_owner' to 'read/write' on Mirrored database . Database will be Read-only .

    Provide all your inputs on the above . 🙂

    Thanks in Advance

    Sireesha

    There is no issue as the rights on a database is user-oriented or database role oriented, both objects embedded in the database. Your changes will be automatically mirrored without any issue.

    The rights that are given at the server level and OS level will not be mirrored. So if your login need to write/read specific things on disk or if your login has view server state granted for example, you need to apply those rights on both servers.

    Clement