Post reply

User Defined Server Roles in SQL2012

  • July 5, 2013 at 12:51 pm

    #275870

    When using UD Server Roles do you still have to map logins to db's at the "Security>Login level"?

    Was hoping to just add logins to the server role without mapping db users to each login.

  • July 8, 2013 at 1:46 am

    #1630332

    Yes, you still have to give DB access to the logins.

    User-defined server roles simply offer you a more granular option to defeine server permissions,but you still have to set database access and permissions.

    [font="Verdana"]Markus Bohse[/font]

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

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