Oracle kill session command
We create a named credential and give the admins the permission to use it.
#Oracle kill session command password#
The application adninistrators don’t have to know the password for the created user with the ALTER privileges. The role is now created and be granted to a user. For EM13c use: Manage Database Sessions.This user has to be created in every target database.Īctivate the checkbox for the privilige Connect to any viewable target and scroll downĪdd database targets and set the Manage Targets Privilege Grants we build an Enterprise Manager report which shows us the ALTER SYSTEM actions based on a metric extension.we create a new named credential with the new user and grant it to the application administrators.we create a new Enterprise Manager role for the application administrators.we enable auditing for ALTER SYSTEM commands in the target databases.
![oracle kill session command oracle kill session command](https://i.stack.imgur.com/mTH8w.png)
![oracle kill session command oracle kill session command](https://img1.daumcdn.net/thumb/R1280x0/?scode=mtistory2&fname=https:%2F%2Fblog.kakaocdn.net%2Fdn%2Fb7Lm7P%2FbtqHy6r95e1%2FV0TMJKUK4tfXOQRPaxfOJ1%2Fimg.png)
Sure, we can build a small PL/SQL procedure on every database and give them the executions rights so they can kill a session in their terminal theirself. Until now they called the DBA: “Please do it for me”.
![oracle kill session command oracle kill session command](https://geodatamaster.files.wordpress.com/2019/04/pic3.png)
And sometimes, they have to kill a hanging Oracle session. In one of my projects, a small team of well known application administrators is having a read-only account in Enterprise Manager 12c to verify the performance, see the user sessions and many more of their subset of databases. This user is now able to change a lot of parameters like memory parameters, NLS settings etc. Granting the ALTER SYSTEM privilege to a Non-DBA has big risks. Basically to execute a ALTER SYSTEM KILL SESSION command you have to be a) a DBA or b) you need the ALTER SYSTEM privilege.