Adding Users

I am trying to set up my report services so that a "power user" for a
specific set of reports can go and add the users that they want to have
access to the reports. However, the only way that i find this works, is if i
also grant the "power user" access to sql server enterprise manager to create
the user in the server and then grant the user select privledges on the
database. Is there a way to accomplish this using integrated security
without having to have each user entered into the server's user table and
granted individual rights?
thanks for any and all help!
BenYes. The way you are setup right now is you are using the user running the
report credentials as the credentials to get the data. What I do is have a
special, readonly user that is used for the credentials for the report. I
run SQL Server in mixed mode so that I do not have to use a domain account.
Then, the user being logged in is just used to allow access to the report.
This would allow you to do as you want. An added benefit is that the system
would be able to take advantage of connection pooling which is not the case
the way you are running now (for a connection to be shared the connection
string, including username, must be exact match).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ben" <ben_1_ AT hotmail DOT com> wrote in message
news:69402C6A-87E2-416F-AFFF-741CB771DC93@.microsoft.com...
>I am trying to set up my report services so that a "power user" for a
> specific set of reports can go and add the users that they want to have
> access to the reports. However, the only way that i find this works, is
> if i
> also grant the "power user" access to sql server enterprise manager to
> create
> the user in the server and then grant the user select privledges on the
> database. Is there a way to accomplish this using integrated security
> without having to have each user entered into the server's user table and
> granted individual rights?
> thanks for any and all help!
> Bensql