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@203.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=# 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