question

siera_gld avatar image
siera_gld asked

Query Report server directories for user permissions

Is there a vway to query a user id on the reportserver for every directory to find out exact directories and report a user has access to? I need to add a user similar to another and A script for this would come in real handy...
ssrsusers
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
siera_gld avatar image
siera_gld answered
got it select * from catalog where policyID in (select policyID from dbo.PolicyUserRole where userid = 'ac 123' -- User id )
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.