Re: [OT] Database Authentication

[John ORourke <suppressed>]

Not exactly a mod_perl question but I'm sure it's something we've all 
thought about before...

Vladimir S. Tikhonjuk wrote:

>    I want to make a Database Authentication for my site. I have a
> PostgreSQL Database. I made a connect_on_init
> by user 'web_user' to the database.
>    The question is: where better to make  site users ? Create them as
> database users and put into system pg_shadow and pg_group tables or
> create new table, for example 'web_user' and work with it ?
>  
Think about the scope of the application - how many users? is it open to 
the public?  A lot of the time, you should create your own table of 
users - the user has a relationship with the app, the app has a 
relationship with the DB.

http://thedailywtf.com/forums/thread/79206.aspx

cheers
John