Re: DBMS_LDAP equivalent utility in PostgreSQL

Поиск
Список
Период
Сортировка
От Dan Smith
Тема Re: DBMS_LDAP equivalent utility in PostgreSQL
Дата
Msg-id CAK50JrxsRckt96-zhvoR+rMxb5UERHuXx7uNxbYdr5YvFLj2iw@mail.gmail.com
обсуждение исходный текст
Ответ на DBMS_LDAP equivalent utility in PostgreSQL  (Mukesh Rajpurohit <vivasvan1902@gmail.com>)
Ответы Re: DBMS_LDAP equivalent utility in PostgreSQL
Список pgsql-admin
Postgres supports LDAP with config (pg_hba.conf).  That config is not exposed on RDS.

With RDS, you can enable IAM authentication.  This uses IAM for authentication.  You must enable the feature on your RDS instance, create an IAM user / policy, and finally grant rds_iam to the database user.  Users with iam authentication have to call "aws rds generate-db-auth-token" vs and use the response as their password when connecting.

It might be possible to further mix solutions or automate things on AWS, but, those are the building blocks.

There's a link with all the supported RDS Postgres extensions below.

References:

Dan Smith


On Tue, Mar 28, 2023, 01:01 Mukesh Rajpurohit <vivasvan1902@gmail.com> wrote:
Hi All,
              We are migrating pl/sql code from Oracle to PostgreSQL. We have the package DBMS_LDAP in oracle pl/sql code and need to migrate it to PostgreSQL pl/pgsql. Please let me know if DBMS_LDAP equivalent code/ utility is available in PostgreSQL also.

My second related question is regarding ldap. Do we have any open source ldap equivalent extension/ utility in PostgreSQL which is supported in AWS RDS for PostgreSQLtoo? I can use AWS IAM for this purpose but I am looking for some extension/ open source utility for ldap etc which suffice this purpose.

Thanks in advance.

Thanks
Mukesh 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Imran Khan
Дата:
Сообщение: Re: Installing PostGreSQLon Redhat Linux - Help needed
Следующее
От: Mukesh Rajpurohit
Дата:
Сообщение: Re: DBMS_LDAP equivalent utility in PostgreSQL