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