Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 62D70475E10 for ; Tue, 14 Jan 2003 09:12:37 -0500 (EST) Received: from limonero.ti.uam.es (limonero.ti.uam.es [150.244.9.12]) by postgresql.org (Postfix) with ESMTP id 4AC7C475DBC for ; Tue, 14 Jan 2003 09:12:36 -0500 (EST) Received: from couldina.sdi.uam.es (couldina.ti.uam.es [150.244.9.91]) by limonero.ti.uam.es (8.9.3/8.9.3/UAM) with ESMTP id PAA03047 for ; Tue, 14 Jan 2003 15:12:38 +0100 (MET) Received: from embnet.cnb.uam.es (bossa-nova.cnb.uam.es [150.244.80.7]) by couldina.sdi.uam.es (8.11.3/8.11.3/UAM) with ESMTP id h0EECcD23696 for ; Tue, 14 Jan 2003 15:12:38 +0100 Received: from [150.244.80.140] (miserere.cnb.uam.es [150.244.80.140]) by embnet.cnb.uam.es (8.10.1/8.10.1) with ESMTP id h0EECZN10248289 for ; Tue, 14 Jan 2003 15:12:35 +0100 (MET) Mime-Version: 1.0 Message-Id: Date: Tue, 14 Jan 2003 15:12:33 +0100 To: pgsql-admin@postgresql.org From: David Subject: Newbie question Content-Type: multipart/alternative; boundary="============_-1169568942==_ma============" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/146 X-Sequence-Number: 6988 --============_-1169568942==_ma============ Content-Type: text/plain; charset="us-ascii" ; format="flowed" How to grant a whole database for a certain user ? i mean: grant usage on mydb.* to myuser identified by 'mypasswd' Is available something similar with postgres or should i write a shell script, for example? Thank you very much!!! --============_-1169568942==_ma============ Content-Type: text/html; charset="us-ascii" Newbie question
How to grant a whole database for a certain user ?
i mean:
<mysql>
grant usage on mydb.* to myuser identified by 'mypasswd'
</mysql>
Is available something similar with postgres or should i write a shell script, for example?
Thank you very much!!!
--============_-1169568942==_ma============--