Re: SQL 2005, sysobjects and security
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 17 Sep 2007 21:53:43 +0000 (UTC)
Marius Horak (nobody@xxxxxx) writes:
Erland Sommarskog wrote:
For sa the query should still return data.
Seems that you know even less than me.
Obviously I do. I am not at the site, I don't know your environment, and I
can only rely on the information you give me.
Could you run Profile to find out what queries the reporting tool is
submitting when it comes to the conclusion that the table has no columns?
--
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:
- SQL 2005, sysobjects and security
- From: Marius Horak
- Re: SQL 2005, sysobjects and security
- From: Erland Sommarskog
- Re: SQL 2005, sysobjects and security
- From: Marius Horak
- Re: SQL 2005, sysobjects and security
- From: Erland Sommarskog
- Re: SQL 2005, sysobjects and security
- From: Marius Horak
- SQL 2005, sysobjects and security
- Prev by Date: Re: Query/View Privileges
- Next by Date: Re: Set up permissions for developers
- Previous by thread: Re: SQL 2005, sysobjects and security
- Next by thread: Re: Trusted SQL Server connection (SQL 2005)
- Index(es):
Relevant Pages
|
|
