I would never, ever use my user logins as the DB logins. That's just a nightmare to manage.

-dhs


Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"Free speech exercised both individually and through a free press, is a necessity in any country where people are themselves free."
    -- Theodore Roosevelt, 1918


On Apr 2, 2008, at 11:56 AM, McTure, Greg wrote:

In addition to the other suggestions a very quick way to get by this issue may be to consider creating a generic application specific user id in the database and use that id in your existing java app without changing anything. You can then control the user id access with security (roles and permissions) for that generic user within the database (depending on your RDBMS).



You could also consider using database authentication (where the application user must be a user login within the RDBMS) but that would require extending or modifying your login component.



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2008 9:41 AM
To: [email protected]
Subject: [ACFUG Discuss] can external java app use datasources defined in Coldfusion?




Hello,

We have some java application using its own datasource to connect to the database. This requires either hardcoding username and password or put it in a config file. Is there a way for this jav app to use datasources defined in Coldfusion so that java app can share the same db connection pool?


Jay Jayaraman
Central Billing Services
Financial Management and Planning
(404) 498-8453 (W)
(404) 273-7131 (C)
-------------------------------------------------------------
Annual Sponsor - Figleaf Software

To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------


-------------------------------------------------------------
Annual Sponsor - Figleaf Software

To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------

Reply via email to