AD Identity and Roles
in [Reports]
|
Prev: Reporting Service how to create landscape format report in reporti
Next: Custom Assembly, Web Service, and System.Net.WebPermission
From: Max2006 on 3 Jul 2008 10:40 Hi, I am having a bit of challenge with giving access right to our Active Directory users. The problem is I am not able to debug the connection and see what kind identity and role the user is being qualified by reporting services. Is there any existing report or technique that shows the user's identity ***and*** roles on the reporting server? If I have such report, then I can browse the report and see what is the user's identity and roles on the server. Any help would be appreciated, Max
From: "Charles Wang [MSFT]" on 3 Jul 2008 23:06
Hi Max, Thank you for your posting! Regarding this issue, I understand that you would like to show the connecting User ID and the related roles in a report so that you can check the information. If I have misunderstood, please let me know. For retrieving the user's identity, you can directly use the expression "=User!UserID"; for getting the related roles, you can query ReportServer database with the following T-SQL statement: SELECT DISTINCT t2.RoleName,t2.Description,v1.UserName FROM (SELECT * FROM dbo.Users WHERE UserName=(a)UserName) v1 JOIN dbo.PolicyUserRole t1 ON v1.UserID = t1.UserID JOIN dbo.Roles t2 ON t1.RoleID=t2.RoleID ORDER BY t2.RoleName So it is simple for you to create a new report with the dataset with the above T-SQL statement. You can set the parameter @UserName to the expression "=User!UserID" under the Parameters tab on your dataset editor window. Hope this helps. If you have any other questions or concerns, please feel free to let me know. Best regards, Charles Wang Microsoft Online Community Support =========================================================== Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg(a)microsoft.com. =========================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ============================================================ This posting is provided "AS IS" with no warranties, and confers no rights. ========================================================= |