From: Didik Prasetyo <prasetyodidik62@yahoo.com>
To: pgsql-admin@postgresql.org
Date: Sat, 7 May 2011 15:28:58 +0800 (SGT)
Message-ID: <183696.23692.qm@web77310.mail.sg1.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: prasetyodidik62@yahoo.com
Subject: Re:
In-Reply-To: <183696.23692.qm@web77310.mail.sg1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox