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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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