Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 10:54:19 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Problem in compiling Stored procedure

From:		Jeetendra Mistry

Hi ,

I have a small problem in compiling stored procedure. I am using DBC.sysexecsql in my procedure. Following is the error which i got , it seems that there is some issue with grants. Can anyone please let me know what should i do so that my procedure gets compiled.

SPL1078:E(L10), User is not authorized to use the DDL/DCL/Dynamic SQL state

Thanks & Regards,

Jeetendra