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;

使用hxl用户登陆发现无法创建表

[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