Specialized User for backups (with minimal rights)

Moderator: NorbertKrupa

Post Reply
alangano
Newbie
Newbie
Posts: 3
Joined: Fri Oct 12, 2018 5:50 pm

Specialized User for backups (with minimal rights)

Post by alangano » Fri Mar 29, 2019 3:45 pm

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?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Specialized User for backups (with minimal rights)

Post by JimKnicely » Mon Apr 01, 2019 3:26 am

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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Backup & Recovery”