我试图在DB2中使用DDL创建一个用户。我尝试了这个:
CREATE USER 'test_user' IDENTIFIED BY 'password';
我收到此错误消息:
An unexpected token "'test_user'
IDENTIFIED BY 'password'" was found following "CREATE USER ". Expected tokens may include: "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.24.92
当我删除撇号时:
CREATE USER test_user IDENTIFIED BY password
我得到这个:
An unexpected token "USER" was found following "CREATE ". Expected tokens may include: "VARIABLE".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.24.92
我具有完整的管理员权限,并且在云类型:企业计划-单节点上运行DB2 Warehouse
当您查看Db2 Warehouse on Cloud支持的SQL语句时,您会发现没有任何CREATE USER
语句。因此,错误消息。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句