Home » Databases » HOWTO: Extract Stored Procedure Permissions from SAP Sybase IQ

HOWTO: Extract Stored Procedure Permissions from SAP Sybase IQ

SELECT 'grant execute ON ' + USER_NAME(sp.creator) + '.'
    + sp.proc_name + ' TO '
    + USER_NAME(spp.grantee) + ';'
FROM
    sys.sysprocedure sp,
    sys.sysprocperm spp
WHERE sp.proc_id = spp.proc_id
Share Button

Comments

  1. Kannan says:

    Thanks Jason. It saved lot of my time.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Facebook login by WP-FB-AutoConnect