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]
We can not Grant SELECT privileges to entire Database. Granting access to a
schema allows use of that schema. It does not grant access to objects
contained in the schema. You will need to do a grant for each object.
*Bash Script To Provide Read Only Access To Every Table In A PostgreSQL
Database:
Didik Prasetyo wrote on 07.05.2011 09:28:
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
You might consider upgrading, because since 9.x you can do:
GRANT SELECT ON ALL TABLES IN SCHEMA public;
Thomas
-
On 06.05.2011 10:42, Tomasz Chmielewski wrote:
On 04.05.2011 22:27, Tomasz Chmielewski wrote:
Then another pg_clog file disappeared.
OK, I have:
bookstor=# SELECT * FROM core_wot_seq;
sequence_name | last_value | increment_by | max_value | min_value |
cache_value | log_cnt | is_cycled | is_c
