oracle——一个用户对另一个用户所有表进行赋权

一个用户对另一个用户所有表进行赋权

DECLARE
    v_sql VARCHAR2(200);
BEGIN
    FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'LUNA_MCS_JSZLYY') LOOP
        v_sql := 'GRANT SELECT, INSERT, UPDATE, DELETE ON LUNA_MCS_JSZLYY."' || t.table_name || '" TO YH_USER01';
        EXECUTE IMMEDIATE v_sql;
    END LOOP;
END;