--查询所有用户
select * from dba_users;
--创建新用户
create user user1 identified by user1;
--查看所有用户所在表空间
select username, default_tablespace from dba_users;
--查询所有表空间路径
select * from dba_data_files ;
--创建临时表空间
--表空间名:DB_TEMP,存放路径:D:\Microsoft\Oracle_11G_R2\app\oradata\orcl\DB_TEMP.dbf,初始大小:10m,自动扩展每次增加10M,最大可到100M)
create temporary tablespace DB_TEMP tempfile 'D:\Microsoft\Oracle_11G_R2\app\oradata\orcl\DB_TEMP.dbf' size 10M autoextend ON next 10M maxsize 100M;
--创建表空间
--表空间名:DB_1,存放路径:D:\Microsoft\Oracle_11G_R2\app\oradata\orcl\DB_1.dbf,初始大小:100m,自动扩展每次增加10M,最大可到1024M)
create tablespace DB_1 datafile 'D:\Microsoft\Oracle_11G_R2\app\oradata\orcl\DB_1.dbf'
size 100m autoextend on next 10m maxsize 1024m extent management local;
--分配临时表空间和表空间
alter user user1 default tablespace DB_1 temporary tablespace DB_TEMP;
-- 删除表空间
drop tablespace DB_1 including contents and datafiles cascade constraint;
--删除用户
drop user user1 cascade;
-- 查询当前用户的权限
select * from dba_sys_privs where grantee='user1'
--分配权限
grant connect, resource to user1;