public inbox for [email protected]  

help / color / mirror / Atom feed

From: kunwar singh <[email protected]>
To: [email protected]
Subject: How to handle application connectivity change when moving from Oracle to Postgres in GCP
Date: Sun, 10 Sep 2023 13:43:18 -0400
Message-ID: <CAJSrDUojpnXU7gTN51nQ0JO+KzdLJieusMAqm7NYo68UGfv_Ow@mail.gmail.com> (raw)

Hi Listers,

Say we have this App->DB connectivity Model.

APP1
Contains synonyms which point to objects under APP1.

APPOWN
Contains the tables, indexes

And it is a Java application that connects to APP1.

Now when the database is switched from Oracle 19c onprem to CloudSQL
Postgres say v15.
Questions that I have:

1. What needs to be done at the database end in terms of schema setup in
order to ensure the application is able to connect to the relevant tables
without any concerns?
2. Do I need to create users APP1 and APPOWN in postgres? If so, what
privileges are required to be assigned to these?
3. How to tie them with service accounts?
4. With which username/service account does the application make
connection to the database?

I still don't understand user/schema concepts in postgres tbh as I'm
still a noob :)



-- 
Cheers,
Kunwar

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: How to handle application connectivity change when moving from Oracle to Postgres in GCP
  In-Reply-To: <CAJSrDUojpnXU7gTN51nQ0JO+KzdLJieusMAqm7NYo68UGfv_Ow@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox