Re: SQL Query return different result for different user
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Tue, 4 Sep 2007 10:40:38 -0400
Anhtq,
Is the BUILTIN\Administrators group a sysadmin on your server? If so, then
rights should not be an issue. If not, then try to determine what your
function uses to which the BUILTIN\Administrators have no rights.
The code of your function might suggest why you are having this problem, but
there is nothing inherent to SQL Server to simply explain what you are
seeing. For example:
1. The code builds us a temporary from several selects before returning the
results. One of the intermediate selects needs rights that not all users
have.
2. There is some part of the function that is aware of something about the
logins. For a simple example:
WHERE is_member ('SpecialRole') = 1
RLF
"Anhtq" <Anhtq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C7DCF7F-A9F3-430A-98A7-DFE144860CC3@xxxxxxxxxxxxxxxx
Hi,
I have a query who returns different result for different user.
This query is just a "SELECT" from a view (or a function), like this:
Select * From MyList('12345', '67890')
When I logged in as "sa", it returns > 3000 lines (this is the number
expected)
When I logged in as "BUILTIN\Administrator", it returns only 17 lines !!!
Is there someone who knows how to correct this problem ?
Thanks.
.
- Next by Date: Re: SQL Query return different result for different user
- Next by thread: Re: SQL Query return different result for different user
- Index(es):
Relevant Pages
|
|
