opengauss需要授予什么权限才能创建用户?
openGauss=# create database db_test with encoding 'utf8' template = template0;
CREATE DATABASE
openGauss=# create user hxl password 'Gauss@123456';
NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
openGauss=#grant all privileges on database db_test to hxl;
openGauss=#grant all on schema public to hxl;
Log in with hxl user and find that the table cannot be created
[ omm@host134 data ] $ gsql - U hxl - d db_test - h 127.0.0.1 -p 5432
db_test=> create table public.tb_test(id number,name varchar(32));
ERROR: permission denied for schema public
DETAIL: N/A
为什么我的行动受到限制?
发布于 2022-09-21 08:26:57
若要向数据库授予用户完全权限,请执行以下操作:
GRANT ALL PRIVILEGES ON DATABASE db1 to usera;
希望能帮助你!
https://stackoverflow.com/questions/73608654
复制相似问题