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

no commiting after grant rights\usage to user

hello!

i do grant:
GRANT ALL PRIVILEGES ON TABLE daip.table TO daip;
GRANT select on all tables in schema beta_abs, daip TO daip;
GRANT USAGE ON SCHEMA daip, beta_abs to daip;

but some time later - user daip doesnt see tables in schemas. why ?

p.s. when i do commit - its "Cannot use commit while Connection is in auto-commit mode."

Tagged:

Answers

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.