sessions table acces to another user
Moderator: NorbertKrupa
sessions table acces to another user
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.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: sessions table acces to another user
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.