原 人大金仓KES使用sao和sso用户访问security库报错 DETAIL User does not have CONNECT privilege
Tags： 原创人大金仓sao和sso用户security库
👉 本文共约148个字，系统预计阅读时间或需1分钟。
现象
1 2 3 4 | [kingbase@930cc9a72274 ~]$ ksql -d security -U sao ksql: error: could not connect to server: FATAL: permission denied for database "security" DETAIL: User does not have CONNECT privilege. [kingbase@930cc9a72274 ~]$ |
分析
回收了对该库的public的登陆权限：
1 | Revoke connect on database security from public; |
解决
1 | grant connect on database security to public; |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
