From: Michael Fuhr <mike@fuhr.org>
To: santosh dwivedi <mwanaag@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: how to grant select on table using trigger
Date: Fri, 7 Jan 2005 11:05:01 -0700
Message-ID: <20050107180501.GA90377@winnie.fuhr.org> (raw)
In-Reply-To: <20050107103350.19567.qmail@web52103.mail.yahoo.com>
References: <20050107095001.GA81396@winnie.fuhr.org>
<20050107103350.19567.qmail@web52103.mail.yahoo.com>
On Fri, Jan 07, 2005 at 02:33:50AM -0800, santosh dwivedi wrote:
> i want to use trigger because my one of application connects to
> databse and creates tables in database dynamically , other user
> want to acces it . as when application creates table in databse it
> does not GRANT select to other users. thats why i thought to grant
> permission by trigger.
Do you have control over how the application works? Is it possible
to configure or modify the application to issue the appropriate
GRANTs?
> i know the newly created table name is listed in one Table called
> queries. can you pls write sample code so that i can grant permission
> on tables created by application
I *did* show sample code. If it doesn't work for you then please
provide more information, like any error messages that resulted.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, mwanaag@yahoo.com
Subject: Re: how to grant select on table using trigger
In-Reply-To: <20050107180501.GA90377@winnie.fuhr.org>
References: <20050107095001.GA81396@winnie.fuhr.org> <20050107103350.19567.qmail@web52103.mail.yahoo.com> <20050107180501.GA90377@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox