Warning: Role "read_only" cannot be set as default

David_P_1

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?

 

kaurora

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