背景

用户有要求，需要用户A删除用户B下的表数据

测试过程

--用户A
CREATE USER "TEST_A" IDENTIFIED BY <PASSWORD> ;
grant "RESOURCE","PUBLIC","VTI","SOI","SVI" to "TEST_A";
grant CREATE SESSION to "TEST_A";--用户B
CREATE USER "TEST_B" IDENTIFIED BY <PASSWORD> ;
grant "RESOURCE","PUBLIC","VTI","SOI","SVI" to "TEST_B";
grant CREATE SESSION to "TEST_B";--建表
CREATE TABLE "TEST_B"."TABLE_1"(
"id" INT
);--赋权
GRANT DELETE ON TEST_B.TABLE_1 TO TEST_A;
GRANT SELECT ON TEST_B.TABLE_1 TO TEST_A;--测试：用户A
DELETE FROM TEST_B.TABLE_1 WHERE id = '1';
COMMIT;