RE: Authentication and authorizations in Calcite

2023-05-02 Thread Joachim Bloche
regards, Joachim -Message d'origine- De : Julian Hyde Envoyé : lundi 1 mai 2023 19:58 À : dev@calcite.apache.org Objet : Re: Authentication and authorizations in Calcite Thanks for digging these up, Stamatis. I have logged https://issues.apache.org/jira/browse/CALCITE-5681 for DDL

Re: Authentication and authorizations in Calcite

2023-05-01 Thread Julian Hyde
Thanks for digging these up, Stamatis. I have logged https://issues.apache.org/jira/browse/CALCITE-5681 for DDL (GRANT and REVOKE commands). Contributions welcome. Julian > On Apr 29, 2023, at 6:53 AM, Stamatis Zampetakis wrote: > > Following up on the authorization part lots of things can

Re: Authentication and authorizations in Calcite

2023-04-29 Thread Stamatis Zampetakis
Following up on the authorization part lots of things can be achieved through the use of views. Views can be used to restrict the columns and rows that are visible to certain users and it is a common way of handling permissions. Here also two other JIRA tickets with discussion around this topic:

Re: Authentication and authorizations in Calcite

2023-04-28 Thread Julian Hyde
I think Calcite should stay out of the authentication business. The container (not Calcite) should authenticate users and convert them to security principals that Calcite knows about. (Avatica does authentication [1] but it just delegates to a provider.) Regarding authorization. I support

RE: Authentication and authorizations in Calcite

2023-04-26 Thread Joachim Bloche
Hi, I'm discovering Calcite after a customer asked me to enhance a proof of concept they made with it. I could get most things to work as needed and am very impressed with the possibilities offered. But completely stuck on a critical point : I can't find any hint on how to manage