X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 52E9A529D1 for ; Wed, 17 Aug 2005 12:18:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19705-08 for ; Wed, 17 Aug 2005 15:18:50 +0000 (GMT) Received: from mail.kp.org (ktazp5001.kp.org [162.119.241.43]) by svr1.postgresql.org (Postfix) with ESMTP id A6E825298D for ; Wed, 17 Aug 2005 12:18:44 -0300 (ADT) Received: from ktazp599.kp.org ([172.21.128.153]) by mail.kp.org with ESMTP id j7HF9Dim029041 for ; Wed, 17 Aug 2005 11:14:22 -0400 (EDT) Received: from cscrdngat001.crdc.KP.ORG by ktazp599 with ESMTP; Wed, 17 Aug 2005 08:14:05 -0700 To: olly@lfix.co.uk Cc: agold@cbamedia.com, pgsql-admin@postgresql.org Subject: Re: GRANT ALL PRIVILEGES ON DATABASE MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-Id: From: Zuoxin.Wang@kp.org Date: Wed, 17 Aug 2005 08:14:02 -0700 X-MIMETrack: Serialize by Router on CRDC-GWY01/GSVR/KAIPERM(Release 5.0.11 |July 24, 2002) at 08/17/2005 08:17:20 AM, Serialize complete at 08/17/2005 08:17:20 AM Content-Type: multipart/alternative; boundary="=_alternative 0053AEEE88257060_=" X-KP: PPSAV - [172.21.128.153] - 2005-08-17 - 11:14:24 X-Proofpoint-Spam-Score: : 0 X-Spam-Details: rule=notspam policy=default score=0 mlx=0 adultscore=0 adjust=0 reason=mlx engine=3.0.0-05081600 definitions=3.0.0-05081700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.585 required=5 tests=[AWL=-0.064, DNS_FROM_RFC_ABUSE=0.374, HTML_50_60=0.095, HTML_MESSAGE=0.001, NO_REAL_NAME=0.178] X-Spam-Level: X-Archive-Number: 200508/218 X-Sequence-Number: 18537 This is a multipart message in MIME format. --=_alternative 0053AEEE88257060_= Content-Type: text/plain; charset="us-ascii" Could you tell us what is the best way to grant a user who can select all data from all tables, if I don't like to write a script which Andrew memtioned earlier. Thanks. Oliver Elphick Sent by: pgsql-admin-owner@postgresql.org 08/16/2005 05:00 PM Please respond to olly To: Andrew Gold cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] GRANT ALL PRIVILEGES ON DATABASE On Tue, 2005-08-16 at 16:07 -0700, Andrew Gold wrote: > Obviously, I can write a script to iterate through all the tables, but > what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it > doesn't even grant basic access? See the man page for GRANT. It gives the right to create schemas and temporary tables in the database. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org --=_alternative 0053AEEE88257060_= Content-Type: text/html; charset="us-ascii"
Could you tell us what is the best way to grant a user who can select all data from all tables, if I don't like to write a script which Andrew memtioned earlier.

Thanks.



Oliver Elphick <olly@lfix.co.uk>
Sent by: pgsql-admin-owner@postgresql.org

08/16/2005 05:00 PM
Please respond to olly

       
        To:        Andrew Gold <agold@cbamedia.com>
        cc:        pgsql-admin@postgresql.org
        Subject:        Re: [ADMIN] GRANT ALL PRIVILEGES ON DATABASE



On Tue, 2005-08-16 at 16:07 -0700, Andrew Gold wrote:
> Obviously, I can write a script to iterate through all the tables, but
> what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it
> doesn't even grant basic access?

See the man page for GRANT.

It gives the right to create schemas and temporary tables in the
database.

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                ========================================
  Do you want to know God?   http://www.lfix.co.uk/knowing_god.html


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org


--=_alternative 0053AEEE88257060_=--