Re: Permissions on views
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 14:30:42 -0800
Pam Davey (PamDavey@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thanks for your help Erland. Yes, the queries work in SQL 2000 as well as
when run from the Query Analyzer and Management Studio.
There's very little code actually. I have a 3rd party report control
from Component One that renders reports from report definitions stored
in an xml file. I've checked the xml file and the various report
definitions within the file have the correct queries named as their
recordsource.
Thanks for the "GRANT..." thought. Didn't make a difference though.
Still, I appreciate your help.
I'm afraid that there is very little to work on. Maybe the best is to
contact the vendor.
All I can really suggest is to use Profiler to eavesdrop on what the
report tool sends to SQL Server. You can include Error events in
the trace, so you can see if any errors are reported.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: Permissions on views
- From: Erland Sommarskog
- Re: Permissions on views
- Prev by Date: Re: DBO Schema
- Next by Date: Re: IIS (ASP) -> SQLServer Authentication Issue
- Previous by thread: Re: Permissions on views
- Next by thread: Re: Permissions on views
- Index(es):
Relevant Pages
|
|
