oracle 查看用户权限

查看当前用户权限:

select * from user_sys_privs;

查看所有用户：

select * from all_users;

查看dba用户:

select * from dba_users;

查看表空间：

select * from dba_tablespaces;

查看表空间文件

select * from dba_data_files;

创建表空间：

create tablespace CMS 
logging 
datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\tbl_CMS01.dbf'
size 32m 
autoextend on 
next 32m maxsize 20480m 
extent management local; 

--创建cms用户
create user cms identified by cms_bingo_itc default tablespace CMS;

/*第4步：给用户授予权限  */
grant connect,resource,dba to cms;

-- 导出dmp
exp username/password@orcl owner=user file=dms20110808.dmp log=dms20110808.log

-- 导入dmp
imp username/password@orcl fromuser=user touser=user file=dms20110808.dmp log=dms20110808.dmp buffer=102400 commit=y