Created a user, but does not have permission to operate public permissions
db_test=> create table public.tb_test(id number,name varchar(32));
ERROR: permission denied for schema public DETAIL: N/A
Report the error, and then grant grant all privileges to hxl; this permission, but this permission is very large, is there a way to create an account that can only operate a certain library?
openGauss=# grant all privileges to hxl;
ALTER ROLE
openGauss=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------------------------------------------------------------+-----------
hxl | Sysadmin | {}
omm | Sysadmin, Create role, Create DB, Replication, Administer audit, Monitoradmin, Operatoradmin, Policyadmin, UseFT | {}