468,168 Members | 1,674 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,168 developers. It's quick & easy.

SQL Reporting Services Security

Hey Peeps,

My exisiting scenario is SQL2000 with no reporting services, and we use
Microsoft .NET 2003 and Crystal reports to report. This works reasonably ok.
As the ASP.NET application uses one account to access the database, then the
security for who can see a report is managed by the application, so far so
good.

Now im being tasked with moving all the reporting to SQL2005/Reporting
services which I have not used in anger yet. Playing with it, it would seem
that all the security is handle in the standard way that security is handled
for other objects like tables etc.

Im wondering how I could resolve this issue. Guess its a simply matter of
adding access to those specific accounts to allow access to the reports.

However, it would be really usefull to have a custom provider to accept or
reject access to reports based on a table of entries. Is this possible, or
any other ideas.

I hope I made my self understandable
Many Thanks
Aug 18 '07 #1
0 1295

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Teo Lachev | last post: by
reply views Thread by Bungle | last post: by
4 posts views Thread by Fabian von Romberg | last post: by
8 posts views Thread by Woody Splawn | last post: by
1 post views Thread by gcdp | last post: by
reply views Thread by kamranasdasdas | last post: by
reply views Thread by gcreed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.