Hi,
I'm wondering if it's possible to connect to a MS SQL database through
ODBC without specifying username and password within the script. In
other words, I'm concerned that if someone manages to grab my script,
they may have direct access to the database.
Currently I have security permissions set on the database so that the
login script only has read access etc. to look up data. But there will
be a requirement shortly for on-line data transactions.
So is there a way of specifying that the script runs as a service with a
pre-determined logon account and having the odbc connection as an NT
account, whose connection permissions is determined by the script logon.
Hence eliminating the need to write the username and password as in:-
$dbh = DBI->connect('dbi:ODBC:<databasename goes here>', '<username goes
here>', '<password goes here>') or die $DBI::errstr;
Or is there an alternative.............
Oh yeah - running Windows 2K, Apache Ver2.43, ActivePerl 633 (Perl
5.6.1) - all up to date with versions and service packs etc.
Many thanks
Kevin
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
