Execute access for Procedure?

Database
Enthusiast

Execute access for Procedure?

How to check whether the particular user has execute permission for the SP? If not how to grant?

Thanks in advance :)

4 REPLIES
Junior Contributor

Re: Execute access for Procedure?

SELECT UserName
FROM dbc.AllRights
WHERE DatabaseName = aaa AND TableName = bbb
AND AccessRight = 'PE'

GRANT EXECUTE PROCEDURE ON bbb TO xxx

Dieter

Enthusiast

Re: Execute access for Procedure?

Thanks Dieter :)

Enthusiast

Re: Execute access for Procedure?

How to grant this permission to all users? PLease help.

Enthusiast

Re: Execute access for Procedure?

You posted twice :). You can post only in one place and it will be answered. It is answered below under created by you :).

http://forums.teradata.com/forum/general/executing-procedure-by-a-user-other-than-the-creator