Webappication and PostgreSQL login roles

From: Thorsten Kraus <TK-Spam(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Webappication and PostgreSQL login roles
Date: 2007-04-02 17:27:59
Message-ID: 46113D1F.1020708@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I designed a Java web application. The persistence layer is a PostgreSQL
database. The application needs user authentication.
I think it's a good choice to implement this authentication mechanism
via PostgreSQL login roles. So I can create several database login roles
and set the database permissions to this login roles. This is my first
project with the postgres database, so I don't know how I can validate a
login from the website. Is there a best practice to do this or does
PostgreSQL offers a stored procedure like 'authenticateUser(String
username, String password)'?

Thanks for your help.

Bye,
Thorsten

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2007-04-02 17:43:24 Re: Using C# to create stored procedures
Previous Message Anders Nilsson 2007-04-02 16:53:50 ECPG: inserting NULL values when using prepared statements