We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Warning: Role "read_only" cannot be set as default — Vertica Forum

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