Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

permission to limited members of a group Expand / Collapse
Author
Message
Posted Thursday, January 13, 2011 8:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 7:13 AM
Points: 63, Visits: 239
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
Post #1047349
Posted Thursday, January 13, 2011 9:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
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
Post #1047407
Posted Thursday, January 13, 2011 10:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 7:13 AM
Points: 63, Visits: 239
Thanks GSquared for your reply. But for this i need to create a group at domain level if I am not mistaken.
Post #1047416
Posted Tuesday, January 18, 2011 7:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
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
Post #1049320
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse