Users can not delete the current connection

2011-06-23  来源:本站原创  分类:Database  人气:47 

The first step: select username, sid, serial # from v $ session where username = 'user'; check out the relevant information.
Step two: alter system kill session'9, 4 '; use the system to the user you want to delete session values ​​get rid of. Because most system privileges. If there is more than one session value, then it may be necessary to remove a number of times.
The third step: drop user a cascade; attention back to have cashcade. Otherwise unable to perform.