Re: grant all the database object automatically - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: grant all the database object automatically
Date
Msg-id 20050121002241.GA16417@wolff.to
Whole thread Raw
In response to grant all the database object automatically  (Akbar <melinda_sayang@hotpop.com>)
Responses Re: grant all the database object automatically  (Akbar <melinda_sayang@hotpop.com>)
List pgsql-novice
On Thu, Jan 20, 2005 at 17:11:16 +0700,
  Akbar <melinda_sayang@hotpop.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.

pgsql-novice by date:

Previous
From: "Daniel Blavos"
Date:
Subject: Error Help
Next
From: "Mike G."
Date:
Subject: Re: pg_hba.conf and upgrade