pg14新特性Pg_database_owner有啥用处？不能授权，授权时报错：
postgres=# grant pg_database_owner to user_a;
ERROR: role “pg_database_owner” cannot have explicit members
postgres=#
pg_database_owner 是数据库owner,不能显示赋予, 也不能被赋予。
可以将表授权到该role：
star@star=>alter table tab1 OWNER TO pg_database_owner;
ALTER TABLE
或者
star@star=>SELECT
star-# pg_has_role(‘user01’, ‘pg_database_owner’, ‘USAGE’) as priv,
star-# pg_has_role(‘user01’, ‘pg_database_owner’, ‘MEMBER’) as mem,
star-# pg_has_role(‘user01’, ‘pg_database_owner’,
star(# ‘MEMBER WITH ADMIN OPTION’) as admin;
priv | mem | admin
------±----±------
f | f | f
(1 row)
star@star=>alter database star owner to user01;
ALTER DATABASE
star@star=>SELECT
pg_has_role(‘user01’, ‘pg_database_owner’, ‘USAGE’) as priv,
pg_has_role(‘user01’, ‘pg_database_owner’, ‘MEMBER’) as mem,
pg_has_role(‘user01’, ‘pg_database_owner’,
‘MEMBER WITH ADMIN OPTION’) as admin;
priv | mem | admin
------±----±------
t | t | f
(1 row)
评论
有用 1
