I am so excited that I just can't hide it!
Mr Allsopp, when do you think you will have something to show us?
marc
|-----Original Message-----
|From: [EMAIL PROTECTED]
|[mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
|Sent: Thursday, December 21, 2000 10:53 AM
|To: jBoss
|Subject: Re: [jBoss-User] Database Security
|
|
|"Wood, Alan" wrote:
|>
|> Is there any way to have jBoss utilize user accounts when
|connecting to the
|> database?
|>
|> For instance:
|>
|> User test logs into the EJB system.
|> The session gets a connection from the pool
|> The session mutates the connection to use the username "test"
|for accessing
|> the database.
|>
|> The reason for this is that our legacy system records the person that
|> created/updated the record. We'd like to maintain that through
|the use of
|> triggers.
|
|As far as I'm aware, DBMSes don't generally provide a way to change the
|user associated with a session. Certainly JDBC doesn't expose any such
|functionality. The only way to acheive this is to have a separate pool
|for each user (which kind of defeats the purpose of pooling).
|
|The J2EE connector architecture (which I'm slowly working on
|implementing for JBoss) directly supports selecting pooled connections
|based on the caller principal, so when this is done it should be able to
|do what you want. Stay tuned.
|
|Toby.
|--
|Toby Allsopp
|Energy Research Lab
|Peace Software International Ltd
|Ph +64-9-3730400
|
|
|--
|--------------------------------------------------------------
|To subscribe: [EMAIL PROTECTED]
|To unsubscribe: [EMAIL PROTECTED]
|List Help?: [EMAIL PROTECTED]
|
|
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
