oracle命令删除用户：

connect / as sysdba;
 shutdown abort;
 startup;
 drop user user1 cascade;
 exit

oracle命令创建用户：

  create user user1
  identified by values 'fa091872a2cc669c'
  default tablespace user1
  temporary tablespace temp
  profile default
  account unlock;
  -- 4 roles for user1
  grant recovery_catalog_owner to user1 with admin option;
  grant resource to user1 with admin option;
  grant dba to user1 with admin option;
  grant connect to user1 with admin option;
  alter user user1 default role all;
  -- 3 system privileges for user1
  grant select any dictionary to user1 with admin option;
  grant unlimited tablespace to user1 with admin option;
  grant alter any procedure to user1 with admin option;