Vertica grant user create table

vertica

I have users (developers) in Vertica who need to create tables for testing purposes, which will later be deployed under specific production schema.
I do not want them to have the ability to create tables in the production schema though.

Im looking for the grants necessary to allow a user the ability to create tables.
Do most environments create a schema for each user and then grant authorization for the user on that schema or what is the best practice?

Best Answer

Implement roles in you DB.
Manage grants on the schemas using roles definition.(single point)
Grant these roles to your users.

in regards users development, create a schema for each one of them with full rights (ownership) where they can play as much as they want.

Related Solutions

Sql-server – create linked server to vertica

The driver in the connection string needs to be Vertica, not Vertica ODBC Driver 4.1.

EXEC dbo.sp_addlinkedserver 
    @server = N'VERTICA', 
    @srvproduct=N'', 
    -- SQL Server driver
    @provider=N'MSDASQL',
    -- Connection string
    @provstr=N'Driver=Vertica;
            Servername=ServerName;
            Port=5433;
            Database=DatabaseName;
            UserName=user;
            Password=pass'

Why bulk loading a Vertica database table does not load all lines

Try option ABORT ON ERROR - will output a reason for rejection.

COPY 'table name' FROM '/path/to/data.txt' DIRECT RECORD TERMINATOR ',' ABORT ON ERROR

Check rejected and exception files or define it in COPY:

COPY 'table name' FROM '/path/to/data.txt' DIRECT RECORD TERMINATOR ',' REJECTED DATA 'path' EXCEPTIONS 'path'

https://community.vertica.com/vertica/topics/bulk_loading

(Original URL is dead; you can try this one instead)

Best Answer

Related Solutions

Sql-server – create linked server to vertica

Why bulk loading a Vertica database table does not load all lines

Related Question