John Smith escribió: > On 9/27/07, John Smith <jayzee.smith@xxxxxxxxx> wrote: > > 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"? > > > > also how'd i find access privileges for a schema. something like "\z > > schemaname" not "\dp schemaname."? > > ok let me ask this one other way: > when i "drop user username" which system tables does it access to then reply: > ERROR: role "username" cannot be dropped... > DETAIL: access to schema schemaname > > where is this "access to schema..." info stored? pg_shdepend -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
