如何查看某个函数被grant给哪个用户了?
例如,grant execute on function f1 to db2inst1
怎么才能查看到确实把f1赋权给db2inst1了?
[解决办法]
SELECT GRANTOR, GRANTORTYPE, GRANTEE, GRANTEETYPE, SCHEMA, SPECIFICNAME, ROUTINETYPE, EXECUTEAUTH, GRANT_TIME
FROM SYSCAT.ROUTINEAUTH
WHERE SPECIFICNAME='f1'