Kill processes
889938Sep 22 2011 — edited Sep 26 2011We 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