[no subject]

[Didik Prasetyo <prasetyodidik62@xxxxxxxxx>]

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@xxxxxxxxxxxxx'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=# CREATE USER udin WITH PASSWORD 'udin';
CREATE ROLE
postgres=# \du
            List of roles
 Role name | Attributes  | Member of
-----------+-------------+-----------
 dba       |             | {}
 postgres  | Superuser   | {}
           : Create role
           : Create DB
 udin      |             | {}

postgres=# \q

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

postgres=# GRANT SELECT ON DATABASE dbmufins to udin;
ERROR:  invalid privilege type SELECT for database

but still there is error, I beg of solutions, from friends all

thank you for your help