Re: access privileges: grant select on (all current and future tables)?

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

John Smith escribió:
> On 9/27/07, John Smith <jayzee(dot)smith(at)gmail(dot)com> wrote:
> > On 9/27/07, John Smith <jayzee(dot)smith(at)gmail(dot)com> 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.