Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / July 2008

Tip: Looking for answers? Try searching our database.

AD Identity and Roles

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Max2006 - 03 Jul 2008 15:40 GMT
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
Charles Wang [MSFT] - 04 Jul 2008 04:06 GMT
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=@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@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.
============================================================
Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.