Coppermill
Programmer
How can I find out from within my Store Proc what Groups my current user is a member of?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Current users Group membership
- Thread starter Coppermill
- Start date
- Status
![[bandito]](/data/assets/smilies/bandito.gif "[bandito] [bandito]")
[blue]DBomrrsm[/blue] - Thread starter
- #3
Coppermill
Programmer
That is a start, I've also found SUSER_SNAME
But the problem is when you use a Trusted connection a user can belong to many Groups, so I need to find a way of getting at al the groups / role the user belongs to.
But the problem is when you use a Trusted connection a user can belong to many Groups, so I need to find a way of getting at al the groups / role the user belongs to.
- Status
Similar threads
- Locked
- Question