Post reply

permission to limited members of a group

  • January 13, 2011 at 8:43 am

    #245347

    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

  • January 13, 2011 at 9:45 am

    #1273146

    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

  • January 13, 2011 at 10:02 am

    #1273154

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

  • January 18, 2011 at 7:13 am

    #1274697

    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