Re: [HACKERS] Granting all tables in schema by one SQL command

2006-10-21 Thread Krycek
Dnia 19-10-2006 o 23:14:07 Merlin Moncure [EMAIL PROTECTED] napisaƂ: What does NEW TABLES mean in this context? the point is to allow tables to inherit permissions from the parent schema. this is actually imo much more important than multiple table grant [...] There was considerable debate on

[HACKERS] Granting all tables in schema by one SQL command

2006-10-19 Thread Krycek
Hello Im new to PostgreSQL development and I would like to make introduce patch that will satisfied this point of TODO: %Allow GRANT/REVOKE permissions to be applied to all schema objects with one command The proposed syntax is: GRANT SELECT ON ALL TABLES IN public TO phpuser; GRANT

Re: [HACKERS] Granting all tables in schema by one SQL command

2006-10-19 Thread Walter Cruz
looks to me that NEW TABLES are the tables created AFTER the GRANT :)Is that?[]'s- WalterOn 10/19/06, Krycek [EMAIL PROTECTED] wrote:HelloIm new to PostgreSQL development and I would like to make introduce patch that will satisfied this point of TODO:%Allow GRANT/REVOKE permissions to be applied

Re: [HACKERS] Granting all tables in schema by one SQL command

2006-10-19 Thread Merlin Moncure
On 10/19/06, Krycek [EMAIL PROTECTED] wrote: The proposed syntax is: GRANT SELECT ON ALL TABLES IN public TO phpuser; GRANT SELECT ON NEW TABLES IN public TO phpuser; GRANT SELECT ON NEW TABLES IN public TO phpuser;? What does NEW TABLES mean in this context? the point is to allow tables