This seems unnecessarily complicated.
Yes, I believe you do have to grant select on every table, but you can
use psql to generate the queries, then execute them.
i.e.
-- show only tuples
/t
-- output to temp script file.
/o script.sql
-- generate your script using pg_tables
SELECT 'GRANT SELECT ON ' || schemaname || '.' || tablename || ' TO d;'
from pg_tables where schemaname = 'abcs';
-- stop writing to script file.
/o
-- run your script
/i script.sql
You can create a cron job that will do these sequence of commands
nightly if you wish.
Hope this helps,
-- Kevin
--
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7
Phone: (250) 383-3022
Email: kneufeld@xxxxxxxxxxxxxxx
A. Kretschmer wrote:
am Tue, dem 28.08.2007, um 10:56:38 +0530 mailte Ashish Karalkar folgendes:
Hello all,
I have a database abc with owner c .
I want to grant only read access on this DB abc to user d.
More specificaly to a schema abcs in the databse abc.
Is ther any way to do so?
I have more than 1000 table so dont want to list all the table name in the
grant command.
Okay:
http://www.archonet.com/pgdocs/grant-all.html
Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
