Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Active Directory Users and memberships

Author  Topic 

DCTFUK
Starting Member

11 Posts

Posted - 2014-11-17 : 10:07:11
I am trying to make all reports on SSRS location specific. e.g I only people who work in certain locations will be able to view certain parameters.

I figured that I can do this using User!User.ID and an access control list. I have tested this by manually creating a sample ACL but I want to be able to automatically populate the list with data from AD.

I can find lots of stuff online that allowed me to extract information from AD but I cannot see a way of creating a full list which includes memberships.

e.g:-
USERNAME MEMBER OF
User1 location1
User1 location2
User1 location3
User2 location1
User2 location4

Does anyone know if this is possible? I have created a ADSI link server.
   

- Advertisement -