All Forums Database
barani_sachin 141 posts Joined 01/12
11 Feb 2013
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 :)

dnoeth 4628 posts Joined 11/04
11 Feb 2013
SELECT UserName
FROM dbc.AllRights
WHERE DatabaseName = aaa AND TableName = bbb
AND AccessRight = 'PE'

GRANT EXECUTE PROCEDURE ON bbb TO xxx

Dieter

Dieter

barani_sachin 141 posts Joined 01/12
11 Feb 2013

Thanks Dieter :)

larun1616 29 posts Joined 09/14
15 Sep 2014

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

Raja_KT 1246 posts Joined 07/09
15 Sep 2014

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.