Different user id and roles are for individuals to access database (using SQL client or other tools). DBCP is for application, you usually have one pool with application id. The application id has all the accesses. You can control access of each individual user within the application.
Andrew Fu Technical Lead PNC Bank, ALM & Market Risk Technologies 23000 Millcreek Blvd. Highland Hills, OH 44122 Phone: 216-488-7832 Mail Stop: B7-YB72-04-6 -----Original Message----- From: 王钦 [mailto:[email protected]] Sent: Thursday, February 16, 2017 9:06 PM To: Commons Users List <[email protected]> Subject: Re: Could DBCP set different username when getConnection Thank you for you suggestion. But it should consume much more system memory... On 2017年02月16日 17:31, John Patrick wrote: > >From my understanding of you question. You would need a pool per role/user. > > John > > > On 16 February 2017 at 08:48, 王钦 <[email protected]> wrote: >> Hi All: >> >> I define some roles and grant different privileges in database. And I >> use DBCP to manage the connection. How could I set different user name when >> I get one connection from DBCP? >> >> Thanks for reading this mail. >> >> >> Qin >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may be considered a commercial electronic message under Canadian law or this message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US law. You may unsubscribe at any time from receiving commercial electronic messages from PNC at http://pages.e.pnc.com/globalunsub/ PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com
