We are using query_profiles table to get query profile data. We are using db user other than dbadmin, but this db user can only see the profile data of itself's query.
Is it possible to use this db user to see profile data from other users' query as well?
Thanks
How to query other user's queries information from
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: How to query other user's queries information from
There is not. You'll need to create a copy of the table that's populated using the dbadmin account.
Checkout vertica.tips for more Vertica resources.