SQL ADP Reports not working due to Authentication rights

[Guest]

Hi all,

I hope you can help me with this one as our db admin person has left. I have
a SQL backend with a ADP frontend. Within the frontend i have set up a combo
box that contains a list of all the access reports you can run, and another
combo that contains criteria for those reports. Behind each report is a
stored procedure that gets the parameters from the form.

This all works fine when i run the reports as I have full rights to the
entire database. but as soon as i apply a AD group to the sql backend these
users can run the reports but it doesn't return any data. This is the same
thing that happens when they try to run the stored proc behind the report.

I am guessing its becuase they dont have the correct access to the stored
procedure. Because it takes in parameters i dont think those users have
access to change the stored procedure when they select a different parameter.

These users have been given execute rights on the stored proc. how can i
give them rights to change this stored procedure?

Hope this makes sense
Thanks in advance
Tanya

 

[Sylvain Lafontaine]

The official newsgroup for ADP is m.p.a.adp.sqlserver.

I really don't understand your explanation of the problem. For example, why
would users need the right to change a stored procedure? The way parameters
are transmitted from the form to the SP behind a report is also far from
clear.

Is this problem only with the reports or if you have also the same kind of
problem with forms?

 

[Guest]

Sorry Sylvain i will post this in the correct place with more info.