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