Options

Ownership change for temp tables

Sergey_Cherepan_1Sergey_Cherepan_1 ✭✭✭
in General Discussion

Hi,

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
Sergey

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...