Post reply

create role to access multiple dn

  • June 5, 2010 at 2:31 pm

    #222325

    how to create a single role to access multiple DB with different perission

    e.g. DBNAME - ABC & XYZ

    db_owner of ABC

    db_datareader on XYZ

    db_datareader & Execute permission on Master db

    then associate user to this role

    Regards

    Jai Verma

  • June 7, 2010 at 9:16 am

    #1177120

    You can't create a single role that works in multiple databases because database roles only exist in the database where they're created.

    If your aim is to allow a group of logins to have different permissions in different databases, you can create (or have created for you) a Windows Group that you can add as a user to each database. This assumes all the logins are domain logins rather than SQL Server logins.

    Greg

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

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