From: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
To: Plugge, Joe R. <JRPlugge@west.com>
Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS] <m.l.wilson@nasa.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgres database user account
Date: Wed, 30 Jun 2010 16:02:39 -0400
Message-ID: <4C2BA2DF.2090900@nasa.gov> (raw)
In-Reply-To: <BD69807DAE0CE44CA00A8338D0FDD08302E49509A9@oma00cexmbx03.corp.westworlds.com>
References: <4C2B97BE.7040405@nasa.gov>
<BD69807DAE0CE44CA00A8338D0FDD08302E49509A9@oma00cexmbx03.corp.westworlds.com>
ok - thanks that makes sense....
so what about the operating system account that is different? What we
are planning on doing with the OS acct (postgres) is only allowing users
sudo ability to this account. Nobody should be able to directly log
into it. Do you think that will cause problems?
thanks again - Maria
Plugge, Joe R. wrote:
> Yes, you can create a role that is a superuser that should be able to do internal work:
>
> CREATE ROLE myuser;
> ALTER ROLE myuser WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'mypassword' VALID UNTIL 'infinity';
>
> If you are talking about the operating system account named postgres, then this is a different question.
>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Maria L. Wilson
> Sent: Wednesday, June 30, 2010 2:15 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] postgres database user account
>
> Hoping someone out there can answer this general question(s).... I am
> having to justify having access to the "postgres" database user account
> to do DBA type work.....
> Is there any specific items that require the postgres database user
> account to run?
>
> Can any general user (with superuser permission) basically do what this
> postgres account does?
>
> thanks, Maria Wilson
> Nasa/Langley Research Center
> Hampton, Virginia 23681
>
>
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: pgsql-admin@postgresql.org
Cc: Maria.L.Wilson-1@nasa.gov, JRPlugge@west.com, m.l.wilson@nasa.gov
Subject: Re: postgres database user account
In-Reply-To: <4C2BA2DF.2090900@nasa.gov>
* 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