Background worker process

From: "Brandl, Wolfgang" <wolfgang(dot)brandl(at)brz(dot)gv(dot)at>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Background worker process
Date: 2017-12-19 12:11:23
Message-ID: F2EB158D72DC6A4F97877DD0BB6F020E6138D650@CMD0MBX-AB01.cmd0.cna.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello
We want to start processes controlled by a prostgres table which acts like crontab.
So we want to start a background worker process which starts the defined functions.

Is it possible to start from a background worker process a child process with a specific User. So this process can only acces the data for his authority.

Like a SQL Intrusion with this definition nobody can start a process a Postgres superuser.

Any idea?
Regards
Wolfgang

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2017-12-19 12:23:04 Re: WG: Extension using the current connection handle
Previous Message Devrim Gündüz 2017-12-19 12:09:17 Re: Couldn't create plperl language