Re: grant all the database object automatically

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Akbar <melinda_sayang(at)hotpop(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: grant all the database object automatically
Date: 2005-01-21 00:22:41
Message-ID: 20050121002241.GA16417@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Jan 20, 2005 at 17:11:16 +0700,
Akbar <melinda_sayang(at)hotpop(dot)com> wrote:
>
> Ok, after this, what should I do to give database objects fully to
> another user beside tables?? Should I alter function, view??? Is there
> any tool or command to give all database objects to another user
> automatically?

There isn't one now, but it isn't too hard to write scripts that query
the database to get a list of objects and than issue corresponding
GRANT or REVOKE commands.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike G. 2005-01-21 01:26:27 Re: pg_hba.conf and upgrade
Previous Message Daniel Blavos 2005-01-20 23:22:03 Error Help