为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:银河麒麟V10服务器操作系统(虚拟机)
【CPU】:4核
【问题描述】*:根据官网的教程一步步的创建用户,填写常规、所属角色、系统权限全选、对象权限选择新建的表空间的表权限全选,结果提交的时候出现报错:
错误号: -2007
错误消息: 第 1 行, 第 2251 列[,]附近出现错误:
语法分析出错
根本无法根据错误详情去找到对应的错误,总不能一个个数到2251列吧?请问这种情况应该怎么解决?
此为报错的sql语句:
grant ALTER DATABASE,RESTORE DATABASE,CREATE USER,ALTER USER,DROP USER,CREATE ROLE,CREATE SCHEMA,CREATE TABLE,CREATE VIEW,CREATE PROCEDURE,CREATE SEQUENCE,CREATE TRIGGER,CREATE INDEX,CREATE CONTEXT INDEX,BACKUP DATABASE,CREATE LINK,CREATE REPLICATE,CREATE PACKAGE,CREATE SYNONYM,CREATE PUBLIC SYNONYM,ALTER REPLICATE,DROP REPLICATE,DROP ROLE,ADMIN ANY ROLE,ADMIN ANY DATABASE PRIVILEGE,GRANT ANY OBJECT PRIVILEGE,CREATE ANY SCHEMA,DROP ANY SCHEMA,CREATE ANY TABLE,ALTER ANY TABLE,DROP ANY TABLE,INSERT TABLE,INSERT ANY TABLE,UPDATE TABLE,UPDATE ANY TABLE,DELETE TABLE,DELETE ANY TABLE,SELECT TABLE,SELECT ANY TABLE,REFERENCES TABLE,REFERENCES ANY TABLE,GRANT TABLE,GRANT ANY TABLE,CREATE ANY VIEW,ALTER ANY VIEW,DROP ANY VIEW,INSERT VIEW,INSERT ANY VIEW,UPDATE VIEW,UPDATE ANY VIEW,DELETE VIEW,DELETE ANY VIEW,SELECT VIEW,SELECT ANY VIEW,GRANT VIEW,GRANT ANY VIEW,CREATE ANY PROCEDURE,DROP ANY PROCEDURE,EXECUTE PROCEDURE,EXECUTE ANY PROCEDURE,GRANT PROCEDURE,GRANT ANY PROCEDURE,CREATE ANY SEQUENCE,DROP ANY SEQUENCE,SELECT SEQUENCE,SELECT ANY SEQUENCE,GRANT SEQUENCE,GRANT ANY SEQUENCE,CREATE ANY TRIGGER,DROP ANY TRIGGER,CREATE ANY INDEX,ALTER ANY INDEX,DROP ANY INDEX,CREATE ANY CONTEXT INDEX,ALTER ANY CONTEXT INDEX,DROP ANY CONTEXT INDEX,CREATE ANY PACKAGE,DROP ANY PACKAGE,EXECUTE PACKAGE,EXECUTE ANY PACKAGE,GRANT PACKAGE,GRANT ANY PACKAGE,CREATE ANY LINK,DROP ANY LINK,CREATE ANY SYNONYM,DROP ANY SYNONYM,DROP PUBLIC SYNONYM,SELECT ANY DICTIONARY,ADMIN REPLAY,ADMIN BUFFER,CREATE TABLESPACE,ALTER TABLESPACE,DROP TABLESPACE,ALTER ANY TRIGGER,CREATE MATERIALIZED VIEW,CREATE ANY MATERIALIZED VIEW,DROP ANY MATERIALIZED VIEW,ALTER ANY MATERIALIZED VIEW,SELECT MATERIALIZED VIEW,SELECT ANY MATERIALIZED VIEW,CREATE ANY DOMAIN,DROP ANY DOMAIN,CREATE DOMAIN,GRANT ANY DOMAIN,GRANT DOMAIN,USAGE ANY DOMAIN,USAGE DOMAIN,CREATE ANY CONTEXT,DROP ANY CONTEXT,GRANT ANY CONTEXT,COMMENT ANY TABLE,DUMP ANY TABLE,DUMP TABLE,ADMIN JOB,CREATE ANY DIRECTORY,DROP ANY DIRECTORY,ALTER ANY SEQUENCE,CREATE PROFILE,ALTER PROFILE,DROP PROFILE,CREATE PARTITION GROUP,CREATE ANY PARTITION GROUP,DROP ANY PARTITION GROUP,USAGE PARTITION GROUP,USAGE ANY PARTITION GROUP,CREATE OPERATOR,CREATE ANY OPERATOR,DROP ANY OPERATOR,FLASHBACK,FLASHBACK ANY TABLE,UNLIMITED TABLESPACE,SUBSCRIBE,DROP TABLE,DROP VIEW,DROP SCHEMA,DROP PROCEDURE,DROP PACKAGE,DROP SEQUENCE,DROP DOMAIN,DROP COLLATION,DROP LINK,DROP OPERATOR,DROP PARTITION GROUP,DROP MATERIALIZED VIEW,DROP CHARACTER SET,DROP SYNONYM,DROP TRIGGER,DROP INDEX,DROP CONTEXT INDEX,ALTER TABLE,ALTER VIEW,ALTER MATERIALIZED VIEW,ALTER SEQUENCE,ALTER TRIGGER,ALTER INDEX,ALTER CONTEXT INDEX to "CS";