The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

different users seeing different data in system monitoring tables

I am seeing some very interesting behaviour. I have 2 users. One I created yesterday and the other I created today. The one I created yesterday is seeing data in the load_Streams table until the 23rd May However, I am seeing current data in the same table with the user that I created today. I have tested this against 2 tables. Load streams and storage_usage. Both users have pseudosuperuser access. Any ideas why this might be happening?


  • Can you please check what is the default role for these users? Even though the users have privilege for pseudosuperuser role, no roles are enabled at the start of a user session if the user has not been assigned with a default role. 

    Other way to enable the role is to run SET ROLE command to activate the role in that session.

    I suspect the users you created might have been running the queries with no roles enabled.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file