The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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?
0
Comments
Did you grant that role to the user before you tried setting it as a default?