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(at)203(dot)142(dot)85(dot)52's password:
Last login: Fri May 6 11:32:08 2011 from 10.10.5.22
cd /us [root(at)dev ~]# cd /usr/local/pgsql/bin/
[root(at)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(at)dev ~]# cd /usr/local/pgsql/bin/
[root(at)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