Search found 3 matches

by Manolo
Tue Feb 09, 2016 10:46 pm
Forum: New to Vertica
Topic: View not visible to other users
Replies: 7
Views: 39065

Re: View not visible to other users

We should fire Joe :lol: 1. Which user created the view? We used a "superuser" to create the view. We have created various views for user joe in the past without issues. 2. Which user granted the SELECT privilege to Joe? Our superuser, the same as the one who created the view 3. What do you mean by ...
by Manolo
Tue Feb 09, 2016 7:23 pm
Forum: New to Vertica
Topic: View not visible to other users
Replies: 7
Views: 39065

Re: View not visible to other users

Thank you for the quick reply! We checked the permissions for user "joe" on all the referenced tables, just in case, and he had permissions on them. User joe claimed that when he ran the query by itself that it ran fine, without any issues. When the query was implemented into a view the user could n...
by Manolo
Mon Feb 08, 2016 11:36 pm
Forum: New to Vertica
Topic: View not visible to other users
Replies: 7
Views: 39065

View not visible to other users

Hello, The other day I encountered a weird situation regarding a view which was not visible to other users even though the grant option was executed. This happened in Vertica 7.1.1: 1. The view was created: CREAT VIEW Schema.ExampleView AS complex query...; 2. GRANT SELECT on Schema.ExampleView TO j...

Go to advanced search