Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 12:32:05 GMT

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

Being DBC there are some restrictions.

Now you are trying to create a procedure under a different user - "DEV_STG_CORE".

For this to work either you should grant permission to DBC to be able to create the stored procedure under user "DEV_STG_CORE" - "grant create procedure on DEV_STG_CORE TO DBC;" and then you compile your procedure.

Or you need to change the context of your current user to "DEV_STG_CORE" - by either the ".logon username" or through "Database <username>;" and then compile your stored procedure.

I hope the procedure that you have listed is placed a separate file and that you tried to compile that file when you received this error.

Narayan

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