Thanks Sergey for the instance response... May I know how to I do this?

Regards.

>Yes, it's similar to stored procedures.
>
>>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.
>>>