oracle创建用户

--创建临时表空间
create temporary tablespace pr_temp
tempfile 'F:\app\data\tablespace\pr_temp.dbf'
size 50m
autoextend on next 50m maxsize 2048m
extent management local;
--创建数据表空间
create tablespace pr_data
logging
datafile 'F:\app\data\tablespace\pr_data.dbf'
size 50m
autoextend on next 50m maxsize 2048m
extent management local;
--查看当前用户的缺省表空间
select username,default_tablespace from user_users;
--查看所有用户表空间
select username,default_tablespace,temporary_tablespace from dba_users where username='PRDB';
--查看所有用户
select * from dba_users;
select * from all_users;
select * from user_users;
--查看当前用户的角色
select * from user_role_privs;
--查看当前用户的系统权限和表级权限
select * from  user_sys_privs;
select * from user_tab_privs;
--查看用户下所有的表
select * from user_tables;
--删除用户
drop user prorderdb cascade;
drop tablespace pr_temp including contents and datafiles;
drop tablespace pr_data including contents and datafiles;
--创建用户并制定表空间
create user prorderdb identified by "123456"
default tablespace pr_data
temporary tablespace pr_temp;
--给用户授权
grant connect,resource to prorderdb;