permission to limited members of a group

  • Hi All,

    I have a windows group added into my SQL Server, this group has approx 35 members.

    Now i need to give permission to 5 users out of these 35 members to a stored procedure.

    Can any one please suggest me is it possible and the best way to do that.

    thanks,

    DKG

  • Move those 5 to a different group, copy the permissions from one to the other, and then add the new permissions to the new group.

    Anything else will be more difficult and more error-prone.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thanks GSquared for your reply. But for this i need to create a group at domain level if I am not mistaken.

  • It's either that or manually put them into a different role in SQL Server.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 4 posts - 1 through 3 (of 3 total)

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