Archives of the TeradataForum
Message Posted: Tue, 28 Feb 2006 @ 13:01:55 GMT
| Subj: | | Re: Compilation problems when try to compile the proceudre |
| |
| From: | | Victor Sokovin |
Hi Srikanth,
| | For the stored procedure I have created both the creation and the owner is same. | |
| | Can you pls. explain me in detail. | |
I thought it might be worth checking when I saw
replace procedure d_dba.enableAuditLog()
in your posting.
Looks like you are trying to create the SP in a database which is not yours. D_DBA becomes the owner of the procedure in this case, and your
user ID is the creator.
Try to create the same procedure as the owner of D_DBA (or ask your DBA to create it for you) to see whether this resolves the issue.
Victor
| 
