Save passwords in scripts

[Florian Lindner]

Esben Pedersen wrote:

> Florian Lindner wrote:
>> Hello,
>> I've a scripts that allows limited manipulation of a database to users.
>> This script of course needs to save a password for the database
>> connection. The users, on the other hand need read permission on the
>> script in order to execute it but should not be able to read out the
>> password. What is the common way to solve this problem?
>> 
>> My current way is to allow the users to execute the script with sudo
>> while not having read permission when acting as a ordinary user. But I
>> don't like this solutions and consider it very ugly.
>> 
>> Thanks,
>> Florian
> 
> Which DB? afaik postgre has user-level authentication which means you
> don't even need a password.

But all users are manipulating rows in one table and I need to check to make
sanity checks on the input.

Florian