Warning: Role "read_only" cannot be set as default

+2

create role read_only;

grant usage on schema public to read_only;

grant select on all tables in schema public to read_only;

create user johnqpublic;

alter user johnqpublic identified by 'johnqpublic123';

alter user johnqpublic default role read_only;

>>Warnings: Role "read_only" cannot be set as default

Why can the role not be given to the user?

Did you grant that role to the user before you tried setting it as a default?

Sign up