Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Essential CGI Security Practices

by pjf (Curate)
on Feb 03, 2002 at 02:07 UTC ( #143002=note: print w/ replies, xml ) Need Help??

in reply to Essential CGI Security Practices

I'm occasionally employed to do security audits for programs both written in Perl and in other languages, and there's one mistake that consistantly pops up and earns me my wage. I've had to give the same piece of advice many many times:

If you're dealing with a database, quote your values - properly.

If you're using DBI and placeholders, then you should never have this problem. Alas, I've seen far too much code that will bomb unexpectedly when Ms O'Donnell enters her surname, or will cost thousands when someone requests a username of '; rollback; begin; drop table customers; commit;. (Note the leading tick.)

If you're doing database work and don't know about the DBI module and placeholders, then go and read up on them now. They're worth it. Really.


Paul Fenwick
Perl Training Australia

Comment on Re: Essential CGI Security Practices

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://143002]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (10)
As of 2015-10-06 21:06 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (160 votes), past polls