--删除用户和表空间
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;
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;