Execute access for Procedure?

Database

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
N/A

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

Re: Execute access for Procedure?

Thanks Dieter :)

Re: Execute access for Procedure?

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

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