Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Kill processes

889938Sep 22 2011 — edited Sep 26 2011
We have a production database in which we have created a db user for an external application. The db user is used for communication between the two systems, i.e. the external application logs into our database with the db user and reads/writes in som specified tables.
Now I wonder if it's possible to give this restricted db user possibility to kill it's own processes. The reason is that the external application sometimes create locks on the tables that the can't remove and we then have to kill the hanging processes.
I would like to give them possibility to kill their own processes (processes started by themselves) without giving them any sysdba priviliges. Is this possible?

Best regards / HÃ¥kan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2011
Added on Sep 22 2011
4 comments
229 views