系统默认用户更改后默认用户无权限问题。

使用的镜像：enmotech/opengauss:5.0.0

指定的环境变量
docker run -itd --name gauss --privileged=true -e GS_USERNAME=ncd -e GS_PASSWORD=Admin@123456 -e GS_DB=ncd -p 15432:5432 enmotech/opengauss:5.0.0

按照如下文档所示给ncd用户授权
https://opengauss.org/zh/blogs/zhengwen2/openGauss%E5%BF%AB%E9%80%9F%E5%AE%89%E8%A3%85%E6%96%B9%E6%B3%95(docker).html

执行的命令:
GRANT ALL PRIVILEGES ON DATABASE ncd to ncd;
GRANT ALL PRIVILEGES ON all tables in schema public TO ncd;

但是使用ncd用户在ncd database的public下创建table；提示错误：
[42501] ERROR: permission denied for schema public

想咨询几个问题：

默认的用户不能修改吗？如果要修改密码的校验方式是不是要修改容器内部的entrypoint.sh的密码校验？
db的时区怎么设置。通过二次构建copy时区文件的方式修改容器的时区后，db的时区还是utc 是要修改某些配置文件吗？
有没有些用户社群，方便讨论一下使用的问题？拜托了谢谢！

期待您的回复，谢谢！

Hey @xiexiuyuan, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss_bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at Here to find the details.

Hi @xiexiuyuan, please use the command /sig xxx to add a SIG label to this issue.
For example: /sig sqlengine or /sig storageengine or /sig om or /sig ai and so on.
You can find more SIG labels from Here.
If you have no idea about that, please contact with @xiangxinyong , @zhangxubo .

sig labels link is nginx 404

/sig docs

Hi @xiexiuyuan,
if you want to get quick review about your issue, please contact the owner in first: @tongdabao , @liyang ,
and then any of the maintainers: @gongsiyi , @kangyang
and then any of the committers: @jiangxiaoying , @Freyaqqianjin , @liyang , @tongdabao , @樊雅清 , @guohuan , @zhang cuiping , @liuxu-enmo , @sky-stars , @renchaoqian , @刘贵宾 , @Kamus , @李轶楠
if you have any question, please contact the SIG: Docs.

GVP openGauss / openGauss-server

内容风险标识

评论 (5)

GVPopenGauss / openGauss-server

内容风险标识