pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: HOWTO? Permissions for user to access a single db
Date: Mon, 13 Feb 2023 16:41:26 -0700
Message-ID: <9fbaac46-18cd-1913-7828-a819e9b69d55@gmail.com> (raw)
In-Reply-To: <CA+QCafdTcDSR8Gk18XMOQ_mNcfgX8pii7KAd5+C0yXgXstensw@mail.gmail.com>
References: <CA+QCafdWu7Qd13wRdjdyubhCtUMhDsuDUZLHYNA7jvqhWjdxbQ@mail.gmail.com>
	<1510083.1676325588@sss.pgh.pa.us>
	<CA+QCafcdMdBtuiyDF_o2h_wac2MDqUxka82MtwAc-Tq8eRLXWA@mail.gmail.com>
	<1515580.1676328872@sss.pgh.pa.us>
	<CA+QCafdTcDSR8Gk18XMOQ_mNcfgX8pii7KAd5+C0yXgXstensw@mail.gmail.com>

On 2/13/23 16:14, Damian Carey wrote:
> Thx Tom
>
> Fine advice that I will follow up.
>
> One tiny thing without wasting (too much) more of your time.
>
> In the working "promiscuous" version they get access the VPS as the 
> same linux user that my product is running on, and superuser PG access.
>
> In the failed version their SSH login is as a different and very 
> limited linux user, as well as their own postgres user name.
>
> Still on a "permissions" theme ... is their any glaring issues that 
> are required to provide a random linux user with permissions to access 
> a DB?
>
> (FYI every few years you graciously help me like this and I'm well 
> aware of our skill difference and the vague questions I regurgitate. 
> Kudos.)
>

I should wait for Tom to respond...

What was the create user command?

Or are you talking about the following?

GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }
     ON DATABASE/|database_name|/  [, ...]
     TO/|role_specification|/  [, ...] [ WITH GRANT OPTION ]
     [ GRANTED BY/|role_specification|/  ]

view thread (10+ messages)  latest in thread

Message-ID: <9fbaac46-18cd-1913-7828-a819e9b69d55@gmail.com>
Permalink:  ../9fbaac46-18cd-1913-7828-a819e9b69d55@gmail.com/
Also on:    postgresql.org/message-id/9fbaac46-18cd-1913-7828-a819e9b69d55@gmail.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: robjsargent@gmail.com
  Subject: Re: HOWTO? Permissions for user to access a single db
  In-Reply-To: <9fbaac46-18cd-1913-7828-a819e9b69d55@gmail.com>
  References: <CA+QCafdWu7Qd13wRdjdyubhCtUMhDsuDUZLHYNA7jvqhWjdxbQ@mail.gmail.com> <1510083.1676325588@sss.pgh.pa.us> <CA+QCafcdMdBtuiyDF_o2h_wac2MDqUxka82MtwAc-Tq8eRLXWA@mail.gmail.com> <1515580.1676328872@sss.pgh.pa.us> <CA+QCafdTcDSR8Gk18XMOQ_mNcfgX8pii7KAd5+C0yXgXstensw@mail.gmail.com> <9fbaac46-18cd-1913-7828-a819e9b69d55@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox