删除并重新创建oracle用户.sql

--删除用户和表空间
  drop user qdky cascade;
  drop tablespace qdkydata including contents and datafiles cascade constraints ;  


--创建表空间
  create tablespace qdkydata
  datafile 'C:\app\Administrator\oradata\orcl\qdkydata' size 1024M  
  autoextend on next 1024M
  extent management local;


--创建用户
  create user qdky 
  identified by qdky                                  
  default tablespace qdkydata
  temporary tablespace temp 
  profile default password expire;
 
--用户授权
  grant connect to qdky with admin option;
  grant resource to qdky with admin option;
  grant create view to qdky with admin option;
  grant unlimited tablespace to qdky with admin option;
  grant debug connect session to qdky with admin option;
  grant  dba  to  qdky with admin option;--新加dba权限
  
--设置密码永不过期
  ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ;
--重新设置用户密码
  alter user  pwd identified by pwd;