Oracle 创建用户 及赋权限

create temporary tablespace test_temp 
tempfile '/opt/oracle/oradata/orcl/pelt01.dbf'
size 6000M 
autoextend on 
next 500M maxsize 10000M 
extent management local; 


create tablespace test_data 
logging datafile '/opt/oracle/oradata/orcl/pelt_data01.dbf'
size 10000M 
autoextend on 
next 500M maxsize 20000M 
extent management local; 


create user pelt identified by pelt 
default tablespace test_data 
temporary tablespace test_temp;

grant connect,resource,dba to pelt;

１)　查看用户信息(账号，密码，状态，默认表空间，用户创建时间)

conn /as sysdba

select  username,password,account_status,default_tablespace,created from dba_users;

２）查看用户权限

 conn oracle/123456

select * from user_sys_privs;

3）修改用户密码

alter user 用户名 identified by新密码;

4）删除用户

drop user 用户名 cascade; 　--//执行该语句请小心，会级联删除该用户下所有对象。 

5）解除授权
revoke dba from 用户名;

6）删除表空间
drop tablespace test_temp including CONTENTS and datafiles;

7）临时表空间的进一步了解

http://blog.itpub.net/17203031/viewspace-1085950/