Authentication and DBI

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi, A very basic doubt abt authentiction in perl. I am using DBI to connect to the oracle database and now am going in for a authentication box where in by typing in the username and passwoird i shud allow the user to enter. The entries of username and password are in the user table in Oracel database. Basically i need to know about authentication that can be done in these kinda sceneriao. Can u please help me out. Thanks,

Comment on Authentication and DBI

Replies are listed 'Best First'.
Re: Authentication by echo (Pilgrim) on Aug 26, 2001 at 14:46 UTC
Is this in a web/CGI context? If so, have a look at mod_auth_oracle. If not, you might still draw good ideas/code from that module.	[reply]
Re: Authentication by blakem (Monsignor) on Aug 26, 2001 at 15:51 UTC
Its really tough to answer your question w/o more information. Assuming you are in a CGI/mod_perl/apache environment, I would highly recommend Lincoln Stein's book Writing Apache Modules in Perl which discusses all the nifty things you can do in during the authorization/authenticaion phases. This includes connecting to a backend database and granting access based on a login and password combo. -Blake	[reply]