MIME-Version: 1.0
From: kunwar singh <krishsingh.111@gmail.com>
Date: Sun, 10 Sep 2023 13:43:18 -0400
Message-ID: 
 <CAJSrDUojpnXU7gTN51nQ0JO+KzdLJieusMAqm7NYo68UGfv_Ow@mail.gmail.com>
Subject: How to handle application connectivity change when moving from Oracle
 to Postgres in GCP
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000063e0eb060504bf71"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJSrDUojpnXU7gTN51nQ0JO%2BKzdLJieusMAqm7NYo68UGfv_Ow%40mail.gmail.com>
Precedence: bulk

--00000000000063e0eb060504bf71
Content-Type: text/plain; charset="UTF-8"

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

--00000000000063e0eb060504bf71
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"auto">Hi Listers,</div><div dir=3D"auto"><br><=
/div><div>Say we have this=C2=A0App-&gt;DB connectivity Model.</div><div><b=
r></div><div>APP1</div><div>Contains synonyms which point=C2=A0to objects u=
nder APP1.</div><div><br></div><div>APPOWN</div><div>Contains the tables, i=
ndexes</div><div><br></div><div>And it is a Java application that connects =
to APP1.</div><div><br></div><div>Now when the database is switched from Or=
acle 19c onprem to CloudSQL Postgres say v15.</div><div>Questions that I ha=
ve:</div><div><br></div><div>1. What needs to be done at the database end i=
n terms of schema setup in order to ensure the application is able to conne=
ct to the relevant tables without any concerns?=C2=A0</div><div>2. Do I nee=
d to create users APP1 and APPOWN=C2=A0in postgres? If so, what privileges =
are required to be assigned to these?</div><div>3. How to tie them with ser=
vice accounts?</div><div>4. With which username/service account does the ap=
plication make=C2=A0 connection to the database?</div><div><br></div><div>I=
 still don&#39;t understand user/schema=C2=A0concepts in postgres tbh as I&=
#39;m still=C2=A0a=C2=A0noob :)=C2=A0<div class=3D"gmail-yj6qo"></div><div =
class=3D"gmail-adL"><br></div></div><div class=3D"gmail-adL"><br></div><div=
><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D=
"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature">Cheers,<=
br>Kunwar</div></div>

--00000000000063e0eb060504bf71--