sql server reporting services: Custom authorization on a particular report -- sql server reporting services

Custom authorization on a particular report

Don
9/23/2004 7:09:05 PM

sql server reporting services:

Hi,

I have created a report that displays order summaries based on a parameter
CustomerName. I have many customers and want to give them all access to this
report. I've installed the Forms Authentication sample and am able to
authenticate, so each customer has a login.

The problem is that I want each customer to be able to view only his own
order summary (i.e. the CustomerName parameter to the report must be set to
the customer's login id and he cannot change it). Is there a way to pass the
username given in Forms Authentication to the report?

Passing it in the URL is no good because users can modify the URL. The
authorization pieces in the Forms Authentication sample seem only to grant or
deny access on to a particular report, but not on parameters to the report.

Any tips would be greatly appreciated.

Thanks,

Re: Custom authorization on a particular report

Bruce Loehle-Conger
9/24/2004 8:42:22 AM

You can use the global user!userid, don't pass this as a parameter.

Bruce L-C

[quoted text, click to view]