Warning: Role "read_only" cannot be set as default

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?



  • Options

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


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file