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