EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

General
Enthusiast

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
Enthusiast

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

Enthusiast

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.

Enthusiast

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.

Enthusiast

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...

Enthusiast

Re: EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR

Perfect!! THanks a lot...