develooper Front page | perl.perl5.porters | Postings from May 2010

Re: Perl programm security

Thread Previous | Thread Next
From:
dreamwvr
Date:
May 11, 2010 07:15
Subject:
Re: Perl programm security
Message ID:
4BE9658D.2020400@dreamwvr.com
Dr.Ruud wrote:
> alex bernier wrote:
> 
>> In my script , i use DBI module  to launch SQL queries ,
>> and i'm looking for a way to hide or to use the queries outside of
>> my script?
> 
> Put the functionality in stored procedures, and make sure only a
> specific database user can get to that code?
> 
postgresql and maybe mysql has event triggers for stored procedures
then you can say way can be done and how. I can't recall the syntax
today. You could also just compile up a binary then call it by perl
as a compiled in apache module. Or use a proxy to buffer sql requests
and have the proxy only understand certain queries..
TMTOWTDI

Best Regards,
dreamwvr@dreamwvr.com

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About