no commiting after grant rights\usage to user
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."