Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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?



  • 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.