We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Ownership change for temp tables — Vertica Forum

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