Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> 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.) regards, tom lane
