oracle创建用户

 1 --创建临时表空间 2 create temporary tablespace pr_temp 3 tempfile 'F:\app\data\tablespace\pr_temp.dbf' 4 size 50m 5 autoextend on next 50m maxsize 2048m 6 extent management local; 7 --创建数据表空间 8 create tablespace pr_data 9 logging10 datafile 'F:\app\data\tablespace\pr_data.dbf'11 size 50m12 autoextend on next 50m maxsize 2048m13 extent management local;14 --查看当前用户的缺省表空间15 select username,default_tablespace from user_users;16 --查看所有用户表空间17 select username,default_tablespace,temporary_tablespace from dba_users where username='PRDB';18 --查看所有用户19 select * from dba_users;20 select * from all_users;21 select * from user_users;22 --查看当前用户的角色23 select * from user_role_privs;24 --查看当前用户的系统权限和表级权限25 select * from  user_sys_privs;26 select * from user_tab_privs;27 --查看用户下所有的表28 select * from user_tables;29 --删除用户30 drop user prorderdb cascade;31 drop tablespace pr_temp including contents and datafiles;32 drop tablespace pr_data including contents and datafiles;33 --创建用户并制定表空间34 create user prorderdb identified by "123456"35 default tablespace pr_data36 temporary tablespace pr_temp;37 --给用户授权38 grant connect,resource to prorderdb;