How to grant a UDF to common role or user.

[Young6688]

How to grant a UDF to common role or user, this shows an error when I called a UDF logging as common user, I also grant the UDF to the role by using "grant SELECT_PRIV on internal.db.UDF to role 'readonly';"

[ixzc]

you should grant these privilege, which depends on your UDF function

[Young6688]

Thank you for your reply.
I have granted "normal" workload group to the role by using "grant USAGE_PRIV on WORKLOAD GROUP 'normal' to role 'readonly'", it doesn't work.

[Young6688]

I think the same problem hanppend on my server, is it a bug?
https://ask.selectdb.com/questions/D1hJ1/zi-ding-yi-function-dang-doris-zhong-qi-yi-hou-fa-xian-bu-fen-yong-hu-mei-you-fang-wen-zi-ding-yi-function-de-quan-xian

[Young6688]

I solve this problem by creating global funtion and recreate it every time i restart server.