EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

General

EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

HI

    I have created a procedure and i am able to call and execute. When some one else try to execute the same procedure, they get a error saying "THE USER DOES NOT HAVE EXECUTE PERMISSION". Why other users are not able to CALL it even though they do REPLACE PROCEDURE before executing it? Does it require any permissions to enable other users leverage this ? What is the issue? Please help me. THanks.

5 REPLIES

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

Thanks a lot Raja. But can a normal user grant this permission or this can be given only by the ADMIN? Please clarify.

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

Yes Raja, I am able to GRANT permission to a particular user. IS there any option where i can grant the permission to ALL? Please help.

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

grant execute procedure retail to public;

you can refer to granting in this link too:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1149_111A/ch02...

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

Perfect!! THanks a lot...