Re: HOWTO? Permissions for user to access a single db

2023-02-13 Thread Damian Carey
ue, 14 Feb 2023 at 10:58, Adrian Klaver wrote: > On 2/13/23 13:45, Damian Carey wrote: > > Hi, > > > > Amateur question here :-{ Despite using Postgres for 15 years it's > > always been locked safely inside a VPS with Hibernate on top powering a > > Java w

Re: HOWTO? Permissions for user to access a single db

2023-02-13 Thread Damian Carey
nd I'm well aware of our skill difference and the vague questions I regurgitate. Kudos.) Thx -Damian On Tue, 14 Feb 2023 at 09:54, Tom Lane wrote: > Damian Carey writes: > > The PP product is on MSSQL, so they use some connector (sorry, no idea > > what) from the customer P

Re: HOWTO? Permissions for user to access a single db

2023-02-13 Thread Damian Carey
just a pg user permissions issue. Maybe not. -Damian On Tue, 14 Feb 2023 at 08:59, Tom Lane wrote: > Damian Carey writes: > > We now need to provide access to an associate company to a single > database > > (3 tables, ~10k rows) that our java app writes to (not JDBC, via > > Hiber

HOWTO? Permissions for user to access a single db

2023-02-13 Thread Damian Carey
Hi, Amateur question here :-{ Despite using Postgres for 15 years it's always been locked safely inside a VPS with Hibernate on top powering a Java web app. Each customer is on a separate VPS which typically has ~500k rows over about 30 tables. Basic but very effective. We now need to provide ac