Re: SQL ADP Reports not working due to Authentication rights

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?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Tanya" <Tanya@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F3CCC61-88AF-4069-A1C3-E959048CB82D@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: SQL ADP Reports not working due to Authentication
    ... INNER JOIN dbo.PlantAccession ON dbo.Plant.ID = dbo.PlantAccession.Plant_ID ... combo that contains criteria for those reports. ... This all works fine when i run the reports as I have full rights to the ... These Users have execute rights on the stored procedure and read/write ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL ADP Reports not working due to Authentication
    ... Sylvain Lafontaine, ing. ... combo that contains criteria for those reports. ... This all works fine when i run the reports as I have full rights to the ... These Users have execute rights on the stored procedure and read/write ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADP Help
    ... And the stored procedure would be something like: ... > this, if all the SQL statements are on the SQL Server, how would the SQL ... I use that query as a base ... >>> query for almost all of my reports. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SQL ADP Reports not working due to Authentication
    ... "Tanya" wrote: ... combo that contains criteria for those reports. ... This all works fine when i run the reports as I have full rights to the ... These Users have execute rights on the stored procedure and read/write ...
    (microsoft.public.access.adp.sqlserver)
  • Re: which one is correct. !
    ... can most people read the execution plan? ... >> the old reports pulling and summarizing data and how are the new reports ... >>> Use this script as a workload file for the Index Tuning Wizard ... >>> B. Capture the execution of each stored procedure in a SQL Profiler ...
    (microsoft.public.sqlserver.clients)