From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Sven Sporer <s(dot)sporer(at)gmx(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Write to file from pgplsql function |
Date: | 2007-01-02 17:12:57 |
Message-ID: | 20070102171257.GB20066@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Jan 02, 2007 at 10:09:06 +0100,
Sven Sporer <s(dot)sporer(at)gmx(dot)net> wrote:
> Hello,
>
> is there a way to write to a file in the filesystem from a pgplsql function?
>
> The reason for this is the architecture of our user system: Each new database has a file in $PGDATA/users with a list of users who are allowed to connect to this database. In pg_hba.conf is a link to this file. As some users don't have filesystem privileges, but are allowed to add users, they have to be able to call a function in postgres which adds that user to the file.
>
> I appreciate your help, or a tip to improve the user system.
In 8.2, you might have another option. There is now a CONNECT privilege for
databases. So you don't need to list all of your users individually in
the pg_hba.conf file to give only some of them access to particular
databases.
From | Date | Subject | |
---|---|---|---|
Next Message | Saranya Sivakumar | 2007-01-03 16:25:01 | using pg_dump version lower than server version |
Previous Message | A. Kretschmer | 2007-01-02 09:13:07 | Re: Write to file from pgplsql function |