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

One Reply to “HOWTO: Extract Stored Procedure Permissions from SAP Sybase IQ”

Leave a Reply

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