Thanks for the reply. We are using SQLServer functions in the where statement, is this the same?

Regards.

>What DB objects you want user to have access to? The datareader and datawriter fixed database roles control access to the tables only. To give access to a stored procedure you should use GRANT statement.
>
>>Hi all,
>>
>>Can someone advise me why I need to check the db_owner role to allow the
>>users to access? I have tried to check public,datareader and datawriter but
>>this will not work until I check the db_owner as well.
>>