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


ERROR: Permission denied for relation tran — Vertica Forum

ERROR: Permission denied for relation tran

Vertica 7.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 '123456';
grant read_only to johnqpublic;

//login as johnqpublic

select * from tran

[Vertica][VJDBC](4367) ERROR: Permission denied for relation tran

 

Why would this be an error?

 

Comments

  • If you want the role to be enabled by default for the user, you need to set it as a default role using ALTER USER.

     

      --Sharon

     

Leave a Comment

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