Home > database >  postgres noinherit and grants
postgres noinherit and grants

Time:12-06

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?

CodePudding user response:

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

  • Related