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?
0
Comments
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.
Thanks,
Rupendra