asked on

SSRS report with stored procedure- permission to normal domain user

How can I give permission to normal domain user for ssrs report I created using stored procedure.
Only if I add the user in Domain Admin group- he can see the report, other wise not,
Please suggest any way so that normal users can see the report
http://blog.hoegaerden.be/2009/11/10/reporting-on-data-from-stored-procedures-part-1/
Thanks

Jim Horn

Give this a whirl..

GRANT EXEC ON OBJECT::your_stored_procedure_name TO your_user_name

Open in new window

Preston Cooper

Yes to the execute permissions stated earlier, but also check and make sure the user has read permissions to the SQL Server database as well. Then check the SSRS permissions for the report.

Vitor Montalvão

sharepointDepot, do you still need help with this question?

sharepointDepot

ASKER

Hi Jim,
I did this as solution but it wont worked ,so on priority basis I gave permissions to 2 users with bit more level, but for all users, I required to find the solution,
sorry for bit delay in reply since -I am in midst of few urgent things-will keep you posted on same line asap,please share your suggestion also

Vitor Montalvão

Giving permission for an AD group doesn't work?

ASKER CERTIFIED SOLUTION

sharepointDepot

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sharepointDepot

ASKER

Hi, none of above mentioned solutions worked as a result I was unable to post further , So whatever is Grade, I wanted to close as suggested answers were first sight googled answers,