Kill user connection from database

I am trying out the detaching of the database and found that there are active user connection to it. The connection has lead to the failed in detaching the database. Can I know how do I kill that user connection? Thanks.

Quote:

Originally Posted by Edwintanst

I am trying out the detaching of the database and found that there are active user connection to it. The connection has lead to the failed in detaching the database. Can I know how do I kill that user connection? Thanks.

Go to Enterprise Manager, expand "Management" in the left pane, expand "Current Activity", then "Locks/Object". Click on your object, then in the right pane double-click the lock, then "Kill process".|||Thank you. I will give it a try.