Iwant toaskhowto makeGRANT,whereuserscanonlyperformSELECTonall theTABLE,inthe database,whichI have donethe 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