Обсуждение: DBMS_LDAP equivalent utility in PostgreSQL

Поиск
Список
Период
Сортировка

DBMS_LDAP equivalent utility in PostgreSQL

От
Mukesh Rajpurohit
Дата:
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 

Re: DBMS_LDAP equivalent utility in PostgreSQL

От
Dan Smith
Дата:
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 

Re: DBMS_LDAP equivalent utility in PostgreSQL

От
Mukesh Rajpurohit
Дата:
Thanks Dan.

On Wed, Mar 29, 2023, 6:50 AM Dan Smith <j.daniel.smith1@gmail.com> wrote:
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