You've mischaracterized the problem a bit. Users with the 'sde' password have always
been able to terminate application server processes, and will continue to have this ability
though ArcGIS 10.2. HOWEVER, there is no server process to kill with a Direct Connect
client, therefore database tools are necessary to terminate user sessions. The exact
details of how that can be accomplished vary by RDBMS.
- V