Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: >> Adam wrote: >>> Is it possible to 'GRANT SELECT ON ALL TABLES TO User' in 1 command >>> ? >>> >>> I saw the question in 2003 and wonder if it's still true. > >> Still true, but on the TODO list: > > Also, you can do it today by making a plpgsql function that iterates > through all the tables and does GRANTs. There are examples in the > mailing list archives. (The TODO item would probably have been done > by now if it weren't so easy to work around it.) > One example:
http://www.archonet.com/pgdocs/grant-all.html -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
