Users in psql

From: Jiri Solc <solcji(at)lin(dot)fsid(dot)cvut(dot)cz>
To: "PSQL [ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Users in psql
Date: 2000-07-11 09:39:51
Message-ID: Pine.LNX.4.20.0007111123090.11356-100000@lin.fsid.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin



Hello.

I need some advice about users in postgress. I study man pages, howto and
web but I can not find how to create good privileges for users. I need to
create user with all rights to one database - where he could create and
drop tables, update and select from tables... In mysql it's easy. Here I
now how to create user - but user can do anything. Could you send me some
hint(s) ?

Thanks

--------------------------------------------------
Jiri SOLC *** department of networks and servers
CTU of Prague, Faculty of Mechanical Engineering
Information Centre FS CVUT * solcji(at)fsid(dot)cvut(dot)cz
(LiNUX - live freeBSD or die)

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Sargent 2000-07-11 16:30:45 Cusor handling
Previous Message Jochen Topf 2000-07-11 07:01:01 Re: Running Postgres 7.0.2 in a chroot environment