[GitHub] [incubator-linkis] Andywli commented on issue #2800: [Question] The database on the right side of Scriptis cannot be refreshed, and it is being refreshed all the time

[GitBox <gi...@apache.org>]

Andywli commented on issue #2800:
URL: https://github.com/apache/incubator-linkis/issues/2800#issuecomment-1216288969

   这是因为右侧的数据库我们是限制了权限的，而这个依赖hive开启授权访问：
   `hive.security.authorization.enabled=true; `
   
   具体可以参考：https://blog.csdn.net/yancychas/article/details/84202400
   开启如果配置了该参数还没有的话，那就需要给这个用户授予相应的库表权限，执行grant语句，可以参考相同的链接授权部分。
   ```
   # 授权参考以hadoop为例:
   # 进入hive client 查看hadoop用户数据库授权情况：
   show grant user hadoop on database default;
   # 给用户数据库授权情况：
   rt
   ```
   
   如果不想开启权限控制，即每个用户都可以看到库表，
   可以在linkis-ps-publicservice.properties种关闭与登陆用户的强关联配置linkis.metadata.hive.permission.with-login-user-enabled=false，重启linkis-ps-publicservice 后再试试
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@linkis.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@linkis.apache.org
For additional commands, e-mail: notifications-help@linkis.apache.org