azexcy commented on PR #19356: URL: https://github.com/apache/shardingsphere/pull/19356#issuecomment-1189778212
Refer to https://www.postgresql.org/docs/current/sql-createrole.html > The INHERIT attribute governs inheritance of grantable privileges (that is, access privileges for database objects and role memberships). It does not apply to the special role attributes set by CREATE ROLE and ALTER ROLE. For example, being a member of a role with CREATEDB privilege does not immediately grant the ability to create databases, even if INHERIT is set; it would be necessary to become that role via [SET ROLE](https://www.postgresql.org/docs/current/sql-set-role.html) before creating a database. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
