Search found 3 matches
- Tue Feb 09, 2016 10:46 pm
- Forum: New to Vertica
- Topic: View not visible to other users
- Replies: 7
- Views: 39883
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 ...
- Tue Feb 09, 2016 7:23 pm
- Forum: New to Vertica
- Topic: View not visible to other users
- Replies: 7
- Views: 39883
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...
- Mon Feb 08, 2016 11:36 pm
- Forum: New to Vertica
- Topic: View not visible to other users
- Replies: 7
- Views: 39883
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...