Thread: Security issue for postgresql

Security issue for postgresql

From
aravind chandu
Date:
Hi,

        I have a .h file in that there is a function in which there arguments were username and password for the database so that the user should be logged in,for that i need to write my own program.This is something about administrator privileges etc... can any one of you tell me the procedure to do this so that i will start working on it.

Thank You,
Avin.

Re: Security issue for postgresql

From
Tino Wildenhain
Date:
aravind chandu wrote:
> Hi,
>
>         I have a .h file in that there is a function in which there
> arguments were username and password for the database so that the user
> should be logged in,for that i need to write my own program.This is
> something about administrator privileges etc... can any one of you tell
> me the procedure to do this so that i will start working on it.

Maybe you can rephrase your question a bit? Its not clear what you
really want. If its all about credential storage on the client
you might check pgpass:

http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html

Tino

Attachment

Re: Security issue for postgresql

From
"Scott Marlowe"
Date:
On Mon, Sep 15, 2008 at 10:00 AM, aravind chandu <avin_friends@yahoo.com> wrote:
> Hi,
>
>         I have a .h file in that there is a function in which there
> arguments were username and password for the database so that the user
> should be logged in,for that i need to write my own program.This is
> something about administrator privileges etc... can any one of you tell me
> the procedure to do this so that i will start working on it.

If you need to run a procedure as a super user, look into security definer.