Disable user (terminate session), you can do (in sqlplus):

  1. find the desired user on the “osuser” and “machine” in this query:
    select SID, SERIAL #, osuser, machine from v $ session where username = 'scott';

    where:
    the username = ‘scott’ – circuit, which is connected to the user of interest to us

  2. disable the user specified as the argument to the SID and SERIAL #:
    alter system disconnect session '287,596' immediate;

    or

    alter system kill session '287,596';

Note. Naturally the user under which these activities are carried out, should be the appropriate authority.

(Visited 41 times, 1 visits today)
adminOracleTips
Disable user (terminate session), you can do (in sqlplus): find the desired user on the 'osuser' and 'machine' in this query: select SID, SERIAL #, osuser, machine from v $ session where username = 'scott'; where: the username = 'scott' - circuit, which is connected to the user of interest to us disable...

Do you want to be notified about new DBA updates, releases, jobs and free tips? Join our email newsletter. It's fast and easy. You will be among the first to know about hot new DBA updates and stuff, it will help you enhance your DBA skills.
We take your privacy very seriously