3 weeks ago
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?
Peter
Solved! Go to Solution.
3 weeks ago
3 weeks ago
Hi Peter,
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
3 weeks ago
- last edited
3 weeks ago
by
exa-MathiasHo
Thanks @exa-Matze - Unfortunately it is not possible to vote for the IDEA because it is marked as Resolved. Should it be reopened?
3 weeks ago
Hi @PeterK,
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?
3 weeks ago - last edited 3 weeks ago
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:
3 weeks ago
@PeterK Ah, I see. Thank you for the explanation. I don't want to create unrealistic expectations... As it seems not that urgent, It will probably not be worked on soon. Nevertheless, creating an idea is always a great way to keep it on our radar. Thanks again! 🙂
3 weeks ago
Then it's time to become part of a unique family! Discover helpful tips and support other Community members with your knowledge.
Sign In