Users
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
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
"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
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.
Show quoted text
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
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
Show quoted text
user in postgresql?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company