Hi,
I have a requirement to give read access to database users. Does anyone have an opinion if it's best practice to create a view for every table and grant the select privilege on them to users, or simply give read only access directly on the tables?
Thank you.
-J
Search found 3 matches
- Tue Sep 02, 2014 6:02 pm
- Forum: Vertica Security
- Topic: Views vs Table Access
- Replies: 5
- Views: 22368
- Tue Sep 02, 2014 5:58 pm
- Forum: New to Vertica
- Topic: Deletes slow down queries
- Replies: 2
- Views: 6622
Re: Deletes slow down queries
Thanks for the valuable links!
- Fri Aug 29, 2014 8:41 pm
- Forum: New to Vertica
- Topic: Deletes slow down queries
- Replies: 2
- Views: 6622
Deletes slow down queries
Hi! Thanks for the forums site! We are having an issue with deletes. We need to delete a lot of data from tables once a week. It seems like the more we delete, queries against these tables get slower and slower. Is it better to truncate a table and reload only the data we want? Thank for any help on...