Postgres Pro
Downloads
Home   >   mailing lists

Webappication and PostgreSQL login roles - Mailing list pgsql-general

From Thorsten Kraus
Subject Webappication and PostgreSQL login roles
Date
Msg-id 46113D1F.1020708@gmx.de
Whole thread Raw
Responses Re: Webappication and PostgreSQL login roles  (Thorsten Kraus <TK-Spam@gmx.de>)
Re: Webappication and PostgreSQL login roles  (Lutz Broedel <lb@fggm.uni-hannover.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexplained case insensitive results
Next
From: David Fetter
Date:
Subject: Re: Using C# to create stored procedures