On 9/27/07, John Smith <jayzee.smith@xxxxxxxxx> wrote: > how'd i "grant select on (all current and future tables inside a > private schema) to username" without turning that user into superuser? > "grant usage on..." doesn't do it. > > or do i, everytime i batch/auto create the tables, do a "grant select > on (new table) to username"? ok did some more googling. seems like "grant" is not the strongest feature of postgresql yet. for those who follow: "grant select on schemaname.tablename..." alone works. gotto explicitly mention tablename via trigger/script since schema privilege is separate from table privilige. and "grant usage on new tables in schema..." doesn't exist yet. which leads to my next question (see http://svr5.postgresql.org/pgsql-hackers/2005-01/msg01070.php)- are we there yet? also how'd i find access privileges for a schema. something like "\z schemaname" not "\dp schemaname."? cheers, jzs ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
