Hi,
A semi-OT thing, not CFML but an MSSQL issue.
I recently had a situation where I needed to execute an external
executable from a CF template to do some custom database manipulation
(that couldn't be done any other way). Since the web/cfmx server is
running on Solaris and the external exe and the database is on Windows I
can't use cfexecute (which would have been my prefered way).
So I was looking into xp_cmdshell. The database access is done by a
restricted login, which doesn't have any access to the master database.
I was looking into impersonation and possibly wrapping xp_cmdshell in an
sp in the database for this application, but I didn't get anywhere, it
seemed like I still needed to grant access for this login to
xp_cmdshell?
If anyone has any tips on how to do this, it would be most welcome!
It is not so important anymore though, since I managed to locate a
Solaris version of that executable, and it runs happily started through
cfexecute (and I don't have to worry about the database security!).
/Hugo
--
Hugo Ahlenius
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 230460
UNEP GRID-Arendal Fax: +46 8 230441
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
-------------------------------------------------------------
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206746
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
