From: | Tyson Oswald <tysono(at)iserv(dot)net> |
---|---|
To: | pgsql-questions(at)postgresql(dot)org |
Subject: | Re: How do I create a Postgres user. |
Date: | 1999-09-18 00:10:07 |
Message-ID: | 37E2D85F.4F7F22F0@iserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Suddn
Log into your box as postres and launch psql -d [dbname] by default eh
dbname should be template1. Once logged in type the following
create user [username] with password [password];
like
create user root with password tree;
you will Laos have to grant that user rights to the database.
grant all on [tablename] to [object];
like
grant all on people to root; // people is obviously a table; unfortunately I
don't know how to give them complete access to the database perhaps a option on
the create user function.
I believe the user must be an active account on the box as postgres like
informix uses the current user logging in as the database user. there may also
be a switch for psql, I don't know.
Hope this helps
Tyson Oswald
Suddn wrote:
> Now that I have postgres working I would like to use it. However, it won't
> let me start a session unless I log in using the postgres account.
>
> How do I setup postgres accounts for other users?
>
> Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Palle Girgensohn | 1999-09-18 16:07:14 | pgaccess removed from 6.5.2? |
Previous Message | Paul Wagner | 1999-09-17 21:55:18 | 6.5.2 info hard to find on your site... |