Vertica Database Create User command
Syntax
CREATE USER name
... [ ACCOUNT {LOCK | UNLOCK} ]
... [ IDENTIFIED BY 'password' ]
... [ MEMORYCAP {'memory-limit' | NONE} ]
... [ PASSWORD EXPIRE ]
... [ PROFILE {profile | DEFAULT} ]
... [ RESOURCE POOL pool-name ]
... [ RUNTIMECAP {'time-limit' | NONE} ]
... [ TEMPSPACECAP {'space-limit' | NONE} ]create user "TEST"
identified by "password";
Newly-created users do not have access to schema PUBLIC by default. Make sure to GRANT USAGE ON SCHEMA PUBLIC to all users you create.
To do so give to them the following grant:
GRANT USAGE ON SCHEMA PUBLIC
to TEST; -- where TEST is the user nameIn Vertica new created users have the right to create temporary tables in the database, so no special wrights are needed.
