Options

Granting creation of local temp tables only

amosmossamosmoss
in General Discussion

Hi,

I've been browsing over the docs and forum, and couldn't find how to allow users to create only temp tables.

Maybe I'm missing something, but if there is no way to do that, I would like this feature added to the next Vertica version.

Thanks,
Amos.

Comments

  • Options
    bhanu_kishorebhanu_kishore
    edited May 2017

    Local temporary tables are created in the V_TEMP_SCHEMA namespace and inserted into the user's search path transparently.
    global temporary tables are created in public schema
    By default local tables creation is granted. To create global temp tables user should contain privileges(create , usage) on public schema.
    currently If a user is granted with create privilege he can create both normal and temp tables in that schema.
    But yes vertica can think about this feature.

  • Options
    amosmossamosmoss

    Thanks

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