I have a question about https://www.exasol.com/support/browse/IDEA-327
It's marked as resolved but it still seems the only way to update view comments is via a CREATE OR REPLACE VIEW. Unfortunately, as noted in the IDEA, this causes object privileges to be dropped. Is there a way to add/update view comments that doesn't cause privileges to be dropped?
Solved! Go to Solution.
Views in Exasol are considered as aliases for queries and immutable due to technical restrictions (privileges on views are stored in a kind of ACL attached to users or roles).
That said, there is currently no option to provide comments on views after creation, recreation is mandatory to add comments.
Ideally vote for the IDEA anyway. This will be considered by our Product Management Team for features and improvements
I just talked to the product management and it would be better if you could create a new idea with the requirement that the object privileges are not dropped.
Before you do that, what would you say, how urgent is that idea to you? Are you more frustrated that the privileges are dropped or that you can't add a comment afterwards?
Thanks @exa-MathiasHo - I will create a new idea. It is not urgent - more of an annoyance. We use object comments quite a bit to attach arbitrary metadata to the objects. For us the order of annoyance (most to least) is: