I am trying to use VFP9 to access a stored procedure in our SQL Server database. However, I get the below error when I attempt to call this stored procedure.

lc_conn = SQLCONNECT('my connection string')
=SQLEXEC(lc_conn, 'mystoredproc', 'cust_list')

***AError() reports the following: 
***SQL Server execute permission denied on object 'mystoredproc'

However, I am able to query this SQL Server database with the following, but not as a stored procedure.

***This works.
lc_conn = SQLCONNECT('my connection string')
=SQLEXEC(lc_conn, 'Select * From customer', 'cust_list')

Do I need to see our DBA about permission?

Thanks,

Jerry