>-----Original Message----- >Subject: Get New Record ID in ORACLE >From: Douglas Knudsen <[EMAIL PROTECTED]> >Date: Wed, 8 Jun 2005 22:46:41 -0400 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages >&threadid=40571&forumid=4#209060 ><quote> >"So here is a completely random question. How can a user kill thier own >session in Oracle without having priveleges to kill everyones session? >(i.e. if they logout of the cf app, can we kill that user's session >through a procedure rather than waiting for the session to timeout)" ></quote> > >hmm, if you have connection pooling off in CFs DSN settings, >this happens >immediately. Otherwise I suppose you could run an SP upon >logging out that >kills it, eh? Or just set the timeout sweeper thingy to run >more often. How >often do users actually click logout though, eh?
It could be done because of the definer rights thing - as long as the user who wrote the "killer" sp has the right to kill sessions then the user who is executing it doesn't need to. You'd just have to get your own SID and serial# values and pass them to the sp. Thing is, this isn't a really attractive approach (imho) as it's equivalent to asking somebody to hang up the phone on you (and slam it down at that): why not just hang up yourself? I'd say look into methods for closing/destroying the java connection object from within cf, possibly using a JDBC aware framework like ontap. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54