ERROR: Permission denied for relation tran

David_P_1 · September 2016

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?

Sharon_Cutter · September 2016

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

Comments