It really isn't a nightmare based on roles and permissions and since the logins are centrally managed in one place that would further alleviate any management headaches. This goes back to the age old question about data and applications. Application authentication can be combined with data authentication; however, if the users of the application itself are definitely all users with a database login (such as the case with an internal application designed around specific data) then this can be very useful.
Again, I was only suggesting it in the specific case for a "quick" option in a pinch. ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Wednesday, April 02, 2008 1:01 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] can external java app use datasources defined in Coldfusion? 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: discussion@acfug.org 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 <http://www.figleaf.com> 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 <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> 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 <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com 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 http://www.fusionlink.com -------------------------------------------------------------