【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】oceanbase-standalone-all-in-one-with-ocp-4.3.5_bp3_20250725 安装的observer,没有装ocp,ob版本应该是4.2.1.8
【问题描述】创建了租户,自带的sys能登陆进去,但是,在底下创建的新用户SHAR,加了权限,也还是报1045
【复现路径】
【附件及日志】
[root@localhost ~]# obclient -h 127.0.0.1 -P2881 -usys@sh_tenant -p123456 -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221540398
Server version: OceanBase 4.3.5.3 (r103000112025071821-4b8c513fcc2194bad9eb2f93c789040f6dd01f11) (Built Jul 18 2025 21:12:30)
Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient(SYS@sh_tenant)[SYS]> SELECT username, account_status, created FROM dba_users WHERE username = 'SHAR';
+----------+----------------+-----------+
| USERNAME | ACCOUNT_STATUS | CREATED |
+----------+----------------+-----------+
| SHAR | OPEN | 28-OCT-25 |
+----------+----------------+-----------+
1 row in set (0.001 sec)
obclient(SYS@sh_tenant)[SYS]> GRANT CREATE SESSION TO shar;
Query OK, 0 rows affected (0.017 sec)
obclient(SYS@sh_tenant)[SYS]> Ctrl-C -- exit!
Aborted
[root@localhost ~]# obclient -h 127.0.0.1 -P2881 -uSHAR@sh_tenant -p123456 -A
ERROR 1045 (42000): Access denied for user 'SHAR'@'xxx.xxx.xxx.xxx' (using password: YES)
[root@localhost ~]#