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.