postgresqlpostgrest

postgres noinherit and grants

In the tutorial of postgrest is says:

create role authenticator noinherit login password 'mysecretpassword';
grant web_anon to authenticator;

My question is: why grant privileges of web_anon to authenticator, while authenticator in noinherit?

Solution

  • That is so the authenticator can switch to the web_anon role, as described in https://postgrest.org/en/v9.0/auth.html#authentication-sequence