Re: [ADMIN] Grant SELECT on all tables of a database

2007-05-29 Thread Marsha Ramsey
This does the JOB...thank you very much Oliver Elphick <[EMAIL PROTECTED]> wrote: On Tue, 2007-05-29 at 10:21 -0700, Marsha Ramsey wrote: > Hello all, > > How do I GRANT SELECT to all my tables at once? I have over 1026 > tables in this database... I don't think there is any direct SQL co

Re: [ADMIN] Grant SELECT on all tables of a database

2007-05-29 Thread Oliver Elphick
On Tue, 2007-05-29 at 10:21 -0700, Marsha Ramsey wrote: > Hello all, > > How do I GRANT SELECT to all my tables at once? I have over 1026 > tables in this database... I don't think there is any direct SQL command to do it. But try this: psql -d your_database \t \a \o /tm

[ADMIN] Grant SELECT on all tables of a database

2007-05-29 Thread Marsha Ramsey
Hello all, How do I GRANT SELECT to all my tables at once? I have over 1026 tables in this database... Thanks...Marsha - It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar.