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

Re: Schema security

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Paul Lambert" <paul(dot)lambert(at)reynolds(dot)com(dot)au>
Cc: "pgsql admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Schema security
Date: 2007-12-13 03:25:50
Message-ID: a55915760712121925x401bd12eqf647ca7fade5e6cc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 12/12/07, Paul Lambert <paul(dot)lambert(at)reynolds(dot)com(dot)au> wrote:
> I would have thought giving the user all privileges on a schema would by
> default add them to all objects within it, but clearly not. Do I need to
> explicitly go through every object within the schema and grant that user
> access to them or is there an easier way of doing it? Something like a
> "GRANT CASCADE" option?

You could use pgAdmin's Grant Wizard.

In response to

Responses

pgsql-admin by date

Next:From: Paul LambertDate: 2007-12-13 03:28:45
Subject: Re: Schema security
Previous:From: Medi MontaseriDate: 2007-12-13 02:27:09
Subject: Re: WHERE clause OR vs IN

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