member of a group don't get procedure execute rights RRS feed

  • Question

  • Hi,

    Within Sql Server 2005, I defined a database role which members are different groups of users (Active Directory groups). I granted execute rights on some stored procs to the role. The problem is that the members of the groups don't get the effective execute rights until they are declared as users in the server security logins. When declaring the users in the server security logins, I don't grant them with any rights at all. I don't want to add all the group members in the security logins. How should I proceed?

    Thanks for your help!


    • Moved by Tom Phillips Monday, August 27, 2012 4:31 PM Security question (From:SQL Server Database Engine)
    Monday, August 27, 2012 2:05 PM