How to check whether the particular user has execute permission for the SP? If not how to grant?
Thanks in advance :)
WHERE DatabaseName = aaa AND TableName = bbb
AND AccessRight = 'PE'
GRANT EXECUTE PROCEDURE ON bbb TO xxx
You posted twice :). You can post only in one place and it will be answered. It is answered below under created by you :).