Vertica database System Tables Lock Down

When running a big Data Warehouse on top of HP Vertica the last thing you want is some smart BI analyst running queries on your system tables repositories.
Sensitive information might be there for grabs by some bad intention-ed users.
Also when running Multi-Tenant DW where you have multiple users speared by each project you don`t really want to give this opportunity on seeing resource pools definition or any user
specific definition.

So you wanna keep this access limited to only dbadmin role users.

By default the parameter RestrictSystemTables is set to ,where Allows all users to access system tables.

  • To see the actual value of the RestrictSystemTables parameter:

To restrict access to normal users the parameter RestrictSystemTables value needs to be 1 (Limits access to system tables to database administrator users).

  • To alter the value of the RestrictSystemTables parameter:


This requires a database restart.

Ohh but what is my user needs to see this type of data ?

  • create views on this system tables limited to only each user scope.

Example : 


  •  the user will be able to see only his user definition.



I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click


Similar Article  HP Vertica Hardware Planning Guide
No Comments
Leave a Comment

%d bloggers like this: