Skip to main content
Question

no commiting after grant rights\usage to user

  • April 29, 2022
  • 2 replies
  • 0 views

dancykt

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."

2 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • April 29, 2022

@dancykt : message regarding commit is expected behaviour since the connection was opened in auto commit mode. Could you please share me the error user daip receiving?


SergeB
Forum|alt.badge.img
  • Participating Frequently
  • April 29, 2022

@dancykt Are you refering to tables created after you granted the privileges? If so you might need to enable privilege inheritance at schema level or upon creating the table. https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/AdministratorsGuide/DBUsersAndPrivileges/Privileges/EnableSchemaInheritance.htm