Skip to main content
Question

List of tasks that can be done by only dbadmin user

  • October 26, 2017
  • 2 replies
  • 12 views

SruthiA
Forum|alt.badge.img+1

A customer is looking for list of tasks that can be done by dbadmin user. For example, vbr backup , admintools start database, stop database etc can be done by only dbadmin user. Customer is looking for such an end to end handy list. Thank you for help in advance.

2 replies

jwalsh
  • New Participant
  • January 17, 2018

In regards to the MC, information about roles and privileges can be found in Vertica's documentation: https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/ManagementConsole/GettingStartedWithMC/MCUsersRolesPrivileges.htm


Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • January 17, 2018

Anything done by admintools (dbadmin linux user) is definitely admin only.
You can get a list of all internal functions that are dbadmin only with:
select procedure_name from where is_superuser;
You can get the list of all superuser tables with:
select table_name from system_tables where is_superuser_only order by table_name;