Archives of the TeradataForum
Message Posted: Mon, 06 Aug 2007 @ 12:32:05 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|