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

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

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