This is what we use middleware for. Only 1 database, but security and access is handled in the server objects. We mostly use MTS (Windows servers), but J2EE beans can do the same thing.
Harry Holt Applications Development and Support, CIT Virginia Department of Corrections ================================================ Freedom and fear are at war. The advance of human freedom, the great achievement of our time, and the great hope of every time, now depends on us. George W. Bush > -----Original Message----- > From: Shi, Zhong [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 11:01 AM > To: '[EMAIL PROTECTED]' > Cc: [EMAIL PROTECTED] > Subject: [DB2EUG] How to do it in application or database? -- > Applications to datab ase security strategic > > > Hi, List > > Please give me some ideas. > > What we want is that only the application(s) written for a > database can > access to the database. For example, if we have two applications > PAYROLL1.EXE and PAYROLL2.EXE, we want only PAYROLL1.EXE and > PAYROLL2.EXE be > able to access to the payroll database. In other words, > Microsoft Access > should not be able to access the database even the person > using Microsoft > Access is a valid user for the payroll database. Also, we > want to audit the > individual user who access to the database, which mean you > cannot use a > single useID to run an application. Does any experts here have a good > solution for it? > > Thank you for your suggestion. > > Zhong > DBA > Incepture, Inc. > > > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** You are subscribed to [EMAIL PROTECTED] > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
