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?
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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