用户和表空间

创建用户

create user yanfeng identified by 123456;
grant connect, create session,resource to yanfeng;

强制删除客户

SQL> select sid ,serial# from v$session where username ='ZHANGXIN';

       SID    SERIAL#
---------- ----------
        41       3934
        66       1003
        77       4453
       196       6916

SQL> select * from v$session where username ='ZHANGXIN';