PostgreSQL on SAP BTP authorizations

[Former Member]

manjunath.baburao - we are using cds-pg for a multitenant CAP sample project running on postgreSQL and are having issues with authorization post BTP deployment.

Im able to clone and drop schemas for multitenancy when developing locally using superuser postgres but after BTP deployment, we lose access to any DB superuser.

I have not found a way to to grant permissions to a new or existing cloud DB user in order to create and run procedures (clone / drop schemas). I was able to ssh tunnel into the DB and connect PG Admin but still did not have proper authorizations to create and run DB procedures on our BTP enabled postgres instance.

Am I missing something or is this a short-coming of PostgreSQL hyperscaler service?

sample code: https://github.com/austinkloske22/pg-tacostand

sql statement I'm trying to execute

[Former Member]

Hi austinkloske, if this is SAP Cloud Platform - Cloud Foundry Environment, then it should be the same as if you were on HANA, I suppose. This is not a Postgre SQL on AWS or Azure, is it?

Beyond manjunath.baburao, I would also recommend tagging gregorw

Cheers,

Luis

[former_member235482]

lazfreitas thanks for the reply.

I spoke with Gregor wolf on the issue and he recommended posting here & tagging Manjunath.

This is on SAP Cloud Platform - BTP - postgres hyperscaler micro-service. I do assume that database administration access and tooling will be quite different between HANA / postgresSQL.

For example, multitenancy with HANA can be acheived through SAP provided instance-manager service or through hdbprocedures that clone schemas. We're not yet to that level of grainularity with postgres hyperscaler service.

[Former Member]

Understood. I will keep following the topic and in the case I see anything that can help, I will let you know.

Cheers

[Former Member]

Hi austinkloske,

Have you looked into this post already? Check the "Add and setup the PostgreSQL database" section.

Getting started with CAP on PostgreSQL (Node.js) | SAP Blogs

Hope it helps. Kindly share the outcome once you have it sorted out.

Cheers,

Luis

[former_member235482]

Luis yes I have, I actually mention this article in the pg-tacostand readme git page. I am attempting to expand on the previous cds-pg examples with a multitenant use case. As far as I can tell so far, it's not possible until I get DB superuser access.