Re: Schema security

On 12/12/07, Paul Lambert <paul.lambert@reynolds.com.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.