ado and sp_procedure_params_rowset get nothing columns

Question

Hi,

i'm use an old VB6-Programm,

when the commandobject get a value,

then on the Database (SQLServer 2008) will run the procedure "sp_procedure_params_rowset"

Like this:

Set comProcedur.ActiveConnection = db
comProcedur.CommandType = adCmdStoredProc   
comProcedur.CommandText = "kalk.pTest"   'Parameter zuweisungen   
If ZellenWert(Record, Field).Art = eProzedur.Abmessung Then      
	comProcedur("@FunktionsKennung") = eProzedur.Abmessung                         <----------- sp_procedure_params_rowset   
Else    comProcedur("@FunktionsKennung") = eProzedur.Voreinstellung   
End If

For a normal user (not a DBO Role, only db_datareader and db_datawriter ROLE ) I now get an error message.

What right do I adjust to the DB?

Thanks Mat

Answer 1

If your previous SQL Server was 2000, then there have been some significant changes in permissions starting with SQL Server 2005.

You could try GRANT VIEW DEFINITION to the appropriate scope.  See: http://msdn.microsoft.com/en-us/library/ms175808(v=sql.105).aspx

RLF