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|/ ]
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