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

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 (view raw or flat)
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

pgsql-novice by date

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

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