自建了tempuser的账号,表也建在该账号下,validate decision tables时报权限错误,不知道该给用户赋什么样的权限
Message :
Repository: Encountered an error in repository runtime extension;error preparing statement CREATE PROCEDURE "_SYS_BIC"."TEMPERUSER/CURRENCY_UPDATE" LANGUAGE SQLSCRIPT ASnBEGINnUPDATE "TEMPUSER"."FACTCURRENCYRATE" SET "ENDOFDAYRATE"=n(CASE WHEN "CURRENCYKEY" = 61 THEN ENDOFDAYRATE*1.1nWHEN "CURRENCYKEY" = 100 THEN ENDOFDAYRATE*1.2nnELSE "ENDOFDAYRATE"nENDn);nnnnEND;n for oid {tenant: , package: TEMPERUSER, name: CURRENCY_UPDATE, suffix: hdbruldec}: insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2011
收起