设置 REMOTE_OBJECTS 表的权限,此表允许你在数据混合情景中存储和访问临时缓存数据。警告
如果你重新导入 INA 交付单元(DU),将从 INA_USER 角色删除这些权限,并且需要重新添加。GRANT EXECUTE, INSERT ON SCHEMA "SDI_ADMIN" TO "sap.bc.ina.service.v2.userRole::INA_USER";
GRANT SELECT ON "SYS"."PROCEDURES" TO "sap.bc.ina.service.v2.userRole::INA_USER";CREATE PROCEDURE "SDI_ADMIN"."DATA_READ_##EHS_REMOTE_OBJECTS" (IN remoteId VARCHAR(100), IN objectType VARCHAR(50), OUT outputTable TABLE(OBJECT VARBINARY(5000)))
LANGUAGE SQLSCRIPT
SQL SECURITY DEFINER
READS SQL DATA AS
BEGIN
outputTable = SELECT OBJECT FROM "SDI_ADMIN"."EHS_REMOTE_OBJECTS"
JOIN (SELECT MAX(INSERT_TIME) AS MAX_INSERT_TIME FROM "SDI_ADMIN"."EHS_REMOTE_OBJECTS" WHERE ID=:remoteId AND TYPE=:objectType LIMIT 1)
ON INSERT_TIME = MAX_INSERT_TIME WHERE ID=:remoteId