Granting creation of local temp tables only


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.



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

  • Thanks

Leave a Comment

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