sessions table acces to another user

Moderator: NorbertKrupa

Post Reply
BNegetive
Newbie
Newbie
Posts: 2
Joined: Tue Apr 14, 2015 10:24 am

sessions table acces to another user

Post by BNegetive » Sun Apr 26, 2015 10:20 am

Hello, i found a problem with getting a user to see another user information in sessions table, i tried to create a view with dbadmin and give permisseons to that user on that view, but it seems he can't see another user information anyway, i saw there was no solution for this in the past from vertica forums, but i wanted to ask if there some kind of workaround for this now, except the option of making insert as select, which is really bad solution for this issue.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: sessions table acces to another user

Post by NorbertKrupa » Sun Apr 26, 2015 3:39 pm

This is expected behavior. The only way around this is to copy system table(s) to a physical table. An issue has been filed with Vertica for an enhancement request.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica SQL”