Skip site navigation (1) Skip section navigation (2)

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

From: "John Smith" <jayzee(dot)smith(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: access privileges: grant select on (all current and future tables)?
Date: 2007-09-28 14:07:23
Message-ID: f029597e0709280707n4ccc1960i34653be747eeb162@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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?

In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2007-09-28 14:16:08
Subject: Re: How to avoid: 9.50184e+06
Previous:From: HenrikDate: 2007-09-28 13:41:15
Subject: Preventing selection of data during transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group