Ownership change for temp tables


My LDAP had some problems over weekend, few accounts from LDAPLink get removed and then reinstated.

As expected, tables owned by removed accounts changed ownership to global heir. That includes temp tables.

At same time, I cannot change temp tables ownership - Vertica saying "cannot change temp tables owner".

That is conflicting - Vertica itself is changing temp tables ownership, but not letting me.

Please file ticket to Engineering, ask them to remove restriction on temp tables ownership change. I see no reason why this restriction exist.

Problem show up in v 12.0.4-18, though I believe it will be same in any version.

Thank you


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file