RE: Using Token (JWT) authentication mechanism in Postgres

2018-01-26 Thread Julio Cesar Tenganan Daza
From: Alexander Kukushkin [mailto:cyberd...@gmail.com] Sent: Thursday, January 25, 2018 3:43 AM To: Julio Cesar Tenganan Daza Cc: pgsql-gene...@postgresql.org Subject: Re: Using Token (JWT) authentication mechanism in Postgres Hi, 2018-01-24 22:27 GMT+01:00 Julio Cesar Tenganan Daza

Re: Using Token (JWT) authentication mechanism in Postgres

2018-01-26 Thread Alexander Kukushkin
Hi, > > And also I have an additional question, can the implemented PAM > authentication module be used from JDBC connections? Or they works totally > apart? > I think it should work from JDBC without any additional effort. And basically pam module itself doesn't even know that it is used from p

Re: Using Token (JWT) authentication mechanism in Postgres

2018-01-25 Thread Alexander Kukushkin
Hi, 2018-01-24 22:27 GMT+01:00 Julio Cesar Tenganan Daza : > Hello, > > > > I would like to know if is possible to use Token (JWT) authentication > mechanism in Postgres? In order to authenticate users and also authorize > access to specific tables, This is in a multi-tenant application context

Re: Using Token (JWT) authentication mechanism in Postgres

2018-01-24 Thread James Keener
I believe postgrest can, and you can always use jwt in your application, but postgresql doesn't natively support them. On January 24, 2018 4:27:23 PM EST, Julio Cesar Tenganan Daza wrote: >Hello, > >I would like to know if is possible to use Token (JWT) authentication >mechanism in Postgres? In

Using Token (JWT) authentication mechanism in Postgres

2018-01-24 Thread Julio Cesar Tenganan Daza
Hello, I would like to know if is possible to use Token (JWT) authentication mechanism in Postgres? In order to authenticate users and also authorize access to specific tables, This is in a multi-tenant application context where users can create their own tables and share it if they want. Is i