SQL Query return different result for different user

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.

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" wrote in message

> 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.
>