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?

 

Comments

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

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.