Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 41EB41337BE4 for ; Sat, 7 May 2011 04:29:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 55981-06 for ; Sat, 7 May 2011 07:29:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nm8-vm1.bullet.mail.sg1.yahoo.com (nm8-vm1.bullet.mail.sg1.yahoo.com [115.178.12.204]) by mail.postgresql.org (Postfix) with SMTP id DC3D31337BE1 for ; Sat, 7 May 2011 04:29:01 -0300 (ADT) Received: from [115.178.12.221] by nm8.bullet.mail.sg1.yahoo.com with NNFMP; 07 May 2011 07:28:58 -0000 Received: from [115.178.12.250] by tm2.bullet.mail.sg1.yahoo.com with NNFMP; 07 May 2011 07:28:58 -0000 Received: from [127.0.0.1] by omp1007.mail.sg1.yahoo.com with NNFMP; 07 May 2011 07:28:58 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 279640.30532.bm@omp1007.mail.sg1.yahoo.com Received: (qmail 30968 invoked by uid 60001); 7 May 2011 07:28:58 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1304753338; bh=M3nmfMoZFQZGqeZ/+6C+KxgqQEIsnIpSxIyAF5sMsZM=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:To:MIME-Version:Content-Type; b=ETGmeMSZRU0gnVPcFbfwZIh/MpKHtOtKeicFq+nV3oMlDZg2k4n6+FspxenLBiMZ2FycOl7kUOhYwU0GdnCfPB+YukIocGzOd1ZvXkWSDYVsXed7E1PPT7alQxfqCX2NUCNgmId3JHd+G7hZhAgyXnJp6Qctb3ngIxKponDlUAI= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:To:MIME-Version:Content-Type; b=lcRvy70VLfVQpeaLDGKgZoRCZf67/UWyfIUJza5pRFO+jRVDmoj1eEUWvAnNWf/gMOUOuKpS0r1KaRIlFrWLzCS8JHtFwKrVRcbT6JrThSQsXwxIBOuZMLKeBU4ZdVm4YrrNF2i7U0ksMiponeZPtwlnqhlmxquuYLltFYw3Deo=; Message-ID: <183696.23692.qm@web77310.mail.sg1.yahoo.com> X-YMail-OSG: nvKMNUcVM1nBj8B8K6_zohkovZwiGpAvMQtx9MUYwmP2.p3 08qfMb8i9wYZ0bKu6dgFdLecqV85n81g1pX5uHEYxLgXsRouDAypyZ8yhUv2 JScloV0cDDKGPCYkzrgF87VkTAVYi.kEvxn8xSawRmpFhYRPiogyFIKADQ2f oeBh5Eb64P.QfUWdPtKdAWdTMtNs4F.xT0y5gOpV5d9538kffwhS.pVF1hu4 Z5MkwPzYhJWGFycw_xR0mT1twL_a1rxrZnR.oAQm4YVg4unGF6oED396BLhh aL.vmVkgDlJOKcKlHWfxeC1mKNxYNi2c.7Df1EZ0lXlsvEYC1HtPeHRtUJoN BOyIqddJboFie0A0Dp4voqKHPzaqomxjvpzG5Fb2UBV95pPSj1cI- Received: from [114.79.51.223] by web77310.mail.sg1.yahoo.com via HTTP; Sat, 07 May 2011 15:28:58 SGT X-Mailer: YahooMailRC/559 YahooMailWebService/0.8.110.299900 Date: Sat, 7 May 2011 15:28:58 +0800 (SGT) From: Didik Prasetyo To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1732597588-1304753338=:23692" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.802 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, MISSING_SUBJECT=1.799, RCVD_IN_BL_SPAMCOP_NET=1.347, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: ** X-Archive-Number: 201105/66 X-Sequence-Number: 37503 --0-1732597588-1304753338=:23692 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I want to ask how to make GRANT, where users can only perform SELECT on all= the =0ATABLE, in the database, which I have done the following=0A=0A=0Alog= in as: root=0Aroot@203.142.85.52's password:=0ALast login: Fri May 6 11:32= :08 2011 from 10.10.5.22=0Acd /us [root@dev ~]# cd /usr/local/pgsql/bin/= =0A[root@dev bin]# ./psql -U postgres=0Apsql (8.4.1)=0AType "help" for help= .=0A=0Apostgres=3D# CREATE USER udin WITH PASSWORD 'udin';=0ACREATE ROLE=0A= postgres=3D# \du=0A List of roles=0A Role name | Attributes | M= ember of=0A-----------+-------------+-----------=0A dba | = | {}=0A postgres | Superuser | {}=0A : Create role=0A = : Create DB=0A udin | | {}=0A=0Apostgres=3D# \q=0A=0A[= root@dev ~]# cd /usr/local/pgsql/bin/=0A[root@dev bin]# ./psql -U postgres= =0Apsql (8.4.1)=0AType "help" for help.=0A=0Apostgres=3D# GRANT SELECT ON D= ATABASE dbmufins to udin;=0AERROR: invalid privilege type SELECT for datab= ase=0A=0Abut still there is error, I beg of solutions, from friends all=0A= =0Athank you for your help =0A --0-1732597588-1304753338=:23692 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I want to ask how to make GRANT, where users can only perform SELECT on all the TABLE, in the database, which I have done the following


login as: root
root@20= 3.142.85.52's password:
Last login: Fri May  6 11:32:08 2011 from 10.10.5.22
cd /us  [root@dev ~]= # cd /usr/local/pgsql/bin/
[root@dev bin]# ./psql -U postgres
psql (8= .4.1)
Type "help" for help.

postgres=3D# CREATE USER udin WITH PA= SSWORD 'udin';
CREATE ROLE
postgres=3D# \du
   &nbs= p;        List of roles
 Role na= me | Attributes  | Member of
-----------+-------------+-----------<= br> dba       |    &= nbsp;        | {}
 postgres = ; | Superuser   | {}
       = ;    : Create role
      &n= bsp;    : Create DB
 udin    &nb= sp;=0A |           &= nbsp; | {}

postgres=3D# \q

[root@dev ~]# cd /usr/local/pgsql/= bin/
[root@dev bin]# ./psql -U postgres
psql (8.4.1)
Type "help" f= or help.

postgres=3D# GRANT SELECT ON DATABASE dbmufins to udin;
= ERROR:  invalid privilege ty= pe SELECT for database

but= stil= l the= re is error, I beg of solutions, from friends all

thank you for your help
=0A
--0-1732597588-1304753338=:23692--