Skip to main content
Question

Restore system table

  • October 28, 2022
  • 1 reply
  • 3 views

avinash1
Forum|alt.badge.img+1

Hi,

Can we restore system tables in Vertica?

I need to check the grants provided previously on tables.
Would like to restore Grants table if possible.

Regards,
Avinash

1 reply

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • October 28, 2022

there is no way to restore system tables. However, for future purpose, you can create a view for grants and then reference that view to check previously granted roles etc

https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/InstallationGuide/Upgrade/BackupRestoreGrants.htm