How to query other user's queries information from

Moderator: NorbertKrupa

Post Reply
weikang
Newbie
Newbie
Posts: 16
Joined: Thu Sep 25, 2014 12:06 am

How to query other user's queries information from

Post by weikang » Fri Oct 03, 2014 12:58 am

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

NorbertKrupa
GURU
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

Post by NorbertKrupa » Fri Oct 03, 2014 2:26 am

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.

Post Reply

Return to “New to Vertica Database Administration”