all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Finding the Security Group(s) of User!UserID



Finding the Security Group(s) of User!UserID Todd Chittenden
6/17/2005 9:44:04 AM
sql server reporting services: I can see where the Global Parameter User!UserID will return the domain and
userid of the person logged in. Is there any way to test for membership in a
security group of that user?

In VS.NET there is the User.IsInRole("my_Domain\Security_Group") function
but I cannot seem to equate that in an expression.

Ultimately, I am trying to set the Visibility of a report object based on
the fact that the user is a memeber of a known security group.

Any suggestions?
Thanks.
--
Re: Finding the Security Group(s) of User!UserID Wayne Snyder
6/19/2005 2:43:41 PM
Have you tried putting that code in a function in the Code area?

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"Todd Chittenden" <ToddChittenden@discussions.microsoft.com> wrote in
message news:1128AFB1-BEDE-4D7B-9FC1-CE2C19BECE15@microsoft.com...
[quoted text, click to view]

AddThis Social Bookmark Button