版本:v5.5
1.4 组件与安全说明
当底层服务,kafka,zk,Schema_registry 开启Plain认证后有哪些限制?
当开启Plain认证后,节点高可用,Oracle-agent, Ob-Agent,Db2-CDC的kafka相关功能暂不支持
第三方组件版本:
兼容性标识
| 标识符 | 说明 |
|---|---|
| ✔️ | 支持 |
| ⚠️ | 有限制支持 |
| 🔚 | 停止支持 |
组件第三方版本情况
| 组件名称 | 组件版本 | DP V5.0 | DP V5.0 |
|---|---|---|---|
| MySQL配置库 | 8.0.34 | ✔️ | ✔️ |
| 8.0.36 | ⚠️ 麒麟操作系统不支持MGR | ⚠️ 麒麟操作系统不支持MGR | |
| Oceanbase配置库 | V3.2.4.1 | ✔️ | ✔️ |
| V4.0.0 | ✔️ | ✔️ | |
| 达梦配置库 | V8 | ✔️ | ✔️ |
| KingbaseES配置库 | V8 | ✔️ | ✔️ |
| PostgreSQL | 13.x | ✔️ | ✔️ |
| Kafka | 3.8.1 | ✔️ | ✔️ |
| Redis | 7.4.5 | ✔️ ⚠️ 当Arm操作系统内核版本为4.18.0-193.28.1.el7.aarch64时,不支持该版本 | ✔️ ⚠️ 当Arm操作系统内核版本为4.18.0-193.28.1.el7.aarch64时,不支持该版本 |
| Zookeeper | 3.9.3 | ✔️ | ✔️ |
| Schema_registry | 7.7.1 | ✔️ | ✔️ |
配置库权限说明
| 配置库类型 | 权限说明(最小权限) |
|---|---|
| MySQL配置库 | -- ``1``. 创建用户CREATE USER ``'dp_test'``@``'%' IDENTIFIED BY ``'xxx'``;-- ``2``. 对三个库分别授权GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, EXECUTE ``ONdp-thrall.* TO ``'dp_test'``@``'%'``;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, EXECUTE ``ON coordinator.* TO ``'dp_test'``@``'%'``;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, EXECUTE ``ON connectdp.* TO ``'dp_test'``@``'%'``; |
| OceanBase配置库 | OceanBase - MySQL租户-- ``1``. 创建用户CREATE USER ``'dp_user'``@``'%' IDENTIFIED BY ``'xxx'``;-- ``2``. 对三个库分别授权GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, EXECUTE ``ON dpthrall.* TO ``'dp_user'``@``'%'``;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, EXECUTE ``ON coordinator.* TO ``'dp_user'``@``'%'``;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, EXECUTE ``ON connectdp.* TO ``'dp_user'``@``'%'``;EXECUTE权限只能进行对象级赋权,不能进行库级赋权 OceanBase - Oracle租户 -- ``1``创建连接配置库用户(密码按需替换)CREATE USER ``"dp_test" IDENTIFIED BY ``123456``;-- ``2``创建配置库用户(密码按需替换)需创建两个 OceanBase-Oracle 用户:webservice、coordinator CREATE USER ``"webservice" IDENTIFIED BY ``123456``;CREATE USER ``"coordinator" IDENTIFIED BY ``123456``;-- ``3``分别对两个配置库用户进行授权GRANT CREATE ANY TABLE, ALTER ANY TABLE, CREATE ANY INDEX, CREATE ANY SEQUENCE,SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO webservice/coordinator;GRANT CREATE SESSION TO webservice/coordinator;-- ``4``对连接配置库用户进行授权DECLARE ``v_sql VARCHAR2(``200``);BEGIN ``-- 遍历 SUMMER_WEB 模式下的所有序列 ``FOR seq_rec IN (SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = ``'SUMMER_WEB'``) LOOP ``-- 构建 GRANT 语句 ``v_sql := ``'GRANT SELECT ON SUMMER_WEB.' ` |
| kingbase配置库 | -- ``1``. 创建用户并给用户复制槽权限CREATE USER dp_test WITH PASSWORD ``'123456'``;ALTER USER dp_test WITH REPLICATION;-- ``2``. 对coordinator.env,connectdp.env,manager.env,web.env四个配置文件中配置的数据库和schema进行赋权(需要在所有数据库和schema中执行下列语句)-- 授予数据库连接,创建权限,举例:GRANT CONNECT,CREATE ON DATABASE dp_test1 TO dp_test;GRANT CONNECT,CREATE ON DATABASE dp_test2 TO dp_test;-- 授予schema基础操作权限,举例GRANT USAGE, CREATE ON SCHEMA dp_test1 TO dp_test;-- 授予表级数据操作权限,举例GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA dp_test1 TO dp_test; |
| 达梦配置库 | -- ``1``. 创建用户(达梦用户即 schema)CREATE USER ``"DP_USER" IDENTIFIED BY ``"YourStrongPwd_123"-- ``2``. 对三个 schema 授予对象权限BEGIN ``FOR s IN (``'DPTHRALL'``,``'COORDINATOR'``,``'CONNECTDP'``) LOOP ``EXECUTE IMMEDIATE ``'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER, INDEX, EXECUTE ON SCHEMA ' ` |
| PostgreSQL | 使用新的用户来初始化-- ``1``. 创建用户CREATE USER dp_test WITH PASSWORD ``'Datapipeline123'``;-- ``2``. 给用户在postgres数据库创建schema的权限GRANT CREATE ON DATABASE postgres TO dp_test;切换pg用户-- ``1``. 创建用户CREATE USER dp_test WITH PASSWORD ``'Datapipeline123'``;-- ``2``. 授予 schema 权限GRANT USAGE, CREATE ON SCHEMA ``"dp-thrall"``, coordinator, connectdp TO dp_test;-- ``3``. 授予表权限GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA ``"dp-thrall" TO dp_test;GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA coordinator TO dp_test;GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA connectdp TO dp_test;-- ``4``. 设置默认权限ALTER DEFAULT PRIVILEGES IN SCHEMA ``"dp-thrall" GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON TABLES TO dp_test;ALTER DEFAULT PRIVILEGES IN SCHEMA coordinator GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON TABLES TO dp_test;ALTER DEFAULT PRIVILEGES IN SCHEMA connectdp GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON TABLES TO dp_test; |