Page 1 of 1

Specialized User for backups (with minimal rights)

Posted: Fri Mar 29, 2019 3:45 pm
by alangano
I'd like do backups with a user, other than dbadmin/vertica, which has the minimum rights to do a backup, as it's password is sitting on disk.

Is it even possible? What are minimal set of grants?

Re: Specialized User for backups (with minimal rights)

Posted: Mon Apr 01, 2019 3:26 am
by JimKnicely
Hi,

Only the database admin account (i.e. dbadmin) can backup the database. If you are concerned about the password being saved in the config file, use a Password Configuration File instead.

See:
https://www.vertica.com/docs/9.2.x/HTML ... erence.htm