【达梦数据库】用户A删除用户B下的表数据

背景

用户有要求，需要用户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;