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?
Specialized User for backups (with minimal rights)
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Specialized User for backups (with minimal rights)
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.