Linux下新建oracle用户

su - oracle
sqlplus / as sysdba


the procedure of dropping user are as follow:

select sid,serial# from v$session where username='DP_REPO';
  SID    SERIAL#
---------- ----------
       122        513
       135      14325
       140       6581
       149      10477
       152      34199

alter system kill session '122,513';
alter system kill session '135,14325';
alter system kill session '140,6581';
alter system kill session '149,10477';
alter system kill session '152,34199';
drop user dp_repo cascade;


the procedure of creating user are as follow:

create user dp_repo identified by dp_repo;
alter user dp_repo default tablespace   USERS  quota unlimited on USERS;
alter user dp_repo temporary tablespace temp;
grant connect to dp_repo;
grant resource to dp_repo;
grant create trigger to dp_repo ;
grant create session to dp_repo ;
grant create sequence to dp_repo ;
grant create synonym to dp_repo ;
grant create table to dp_repo ;
grant create view to dp_repo ;
grant create procedure to dp_repo ;