注册

DTS迁移提示无权限

董小姐 2024/02/28 547 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:```language

--创建用户、赋予权限的语句
create user topicis identified by "123456789"
limit failed_login_attemps 3, password_lock_time 10, password_grace_time 10
default tablespace topicis;

grant "DBA","PUBLIC","SOI" to topicis;

--迁移日志中的报错
[INFO] 2024-02-28 03:31:56.993> [TASK]{table-"TOPICIS.SPECIALEQU_LICENSECHANGEINFO"}@CREATE_TABLE:START
[ERROR] 2024-02-28 03:31:56.994> [TASK]{table-"TOPICIS.SPECIALEQU_LICENSECHANGEINFO"}@CREATE_TABLE:FAIL
com.dameng.dts.core.service.TransformServiceException: com.dameng.dts.core.service.TransformServiceException: dm.jdbc.driver.DMException: Error in line: 36
No create table privilege
at com.dameng.dts.core.service.BaseDbService.executeUpdate(BaseDbService.java:1009)
at com.dameng.dts.plugin.support.task.BaseTransformTask.executeUpdateOnDest(BaseTransformTask.java:191)
at com.dameng.dts.plugin.support.task.BaseTransformTask.executeUpdateOnDestWithRetry(BaseTransformTask.java:159)
at com.dameng.dts.plugin.support.task.BaseTransformTask.doRun(BaseTransformTask.java:133)
at com.dameng.common.task.Task.run(SourceFile:127)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:260)
at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:1)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: com.dameng.dts.core.service.TransformServiceException: dm.jdbc.driver.DMException: Error in line: 36
No create table privilege

回答 0
暂无回答
扫一扫
联系客服