Postgres Pro
Downloads
Home   >   mailing lists

Thread: Users

Users

From
"Adam Lang"
Date:
To be a user to interact with postgres, do you have to be a user on the
system it is installed at?

i.e. Jane works from home and uses a program that access the database
remotely.  Does Jane need to be a user on the database server as well as a
user in postgresql?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company

Re: Users

From
Neil Conway
Date:
On Mon, Sep 25, 2000 at 03:45:59PM -0400, Adam Lang wrote:
> To be a user to interact with postgres, do you have to be a user on the
> system it is installed at?

No (although it's possible to set it up that way if you choose).
Database users are independent of system users.

> i.e. Jane works from home and uses a program that access the database
> remotely.  Does Jane need to be a user on the database server as well as a
> user in postgresql?

All Jane needs is a Postgres account (CREATE USER ...).

HTH,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

I am not interested in the past. I am interested in the future for
that is where I intend to spend the rest of my life.
        -- Charles F. Ketterring
Attachment

Re: Users

From
Tom Lane
Date:
"Adam Lang" <aalang@rutgersinsurance.com> writes:
> i.e. Jane works from home and uses a program that access the database
> remotely.  Does Jane need to be a user on the database server as well as a
> user in postgresql?

No.  Postgres users don't have to be related at all to Unix users on the
server's system.

            regards, tom lane

Re: Users

From
Danny
Date:
If you want users to access your database remotely. Goto www.phpwizard.net
or www.phpwizards.net and look for a product call "myPostgresql " (I believe)
which iprovides a web based interface for Postgresql

And ithe program is Free, no licence ietc etc.

On Tue, 26 Sep 2000, Adam Lang wrote:
> To be a user to interact with postgres, do you have to be a user on the
> system it is installed at?
>
> i.e. Jane works from home and uses a program that access the database
> remotely.  Does Jane need to be a user on the database server as well as a
> user in postgresql?
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company

Re: Users

From
"Adam Lang"
Date:
Well, I only want them to access it through a front end.  No one is actually
going to be running straight out queries, creating tables, etc.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Danny" <dannyh@idx.com.au>
To: "Adam Lang" <aalang@rutgersinsurance.com>; "PGSQL General"
<pgsql-general@postgresql.org>
Sent: Tuesday, September 26, 2000 8:21 AM
Subject: Re: [GENERAL] Users


>
> If you want users to access your database remotely. Goto www.phpwizard.net
> or www.phpwizards.net and look for a product call "myPostgresql " (I
believe)
> which iprovides a web based interface for Postgresql
>
> And ithe program is Free, no licence ietc etc.
>
> On Tue, 26 Sep 2000, Adam Lang wrote:
> > To be a user to interact with postgres, do you have to be a user on the
> > system it is installed at?
> >
> > i.e. Jane works from home and uses a program that access the database
> > remotely.  Does Jane need to be a user on the database server as well as
a
> > user in postgresql?
> >
> > Adam Lang
> > Systems Engineer
> > Rutgers Casualty Insurance Company