重庆思庄Oracle、Redhat认证学习论坛

标题: 普通用户要导整个数据库需要什么权限？ [打印本页]

作者: 郑全 时间: 2014-10-31 18:09
标题: 普通用户要导整个数据库需要什么权限？

普通用户 hr进行expdp数据导出，报权限不够的错误

[oracle@dbserver ~]$ expdp hr/hr directory=exp_dir dumpfile=full.dmp full=y

Export: Release 11.2.0.4.0 - Production on Fri Oct 31 17:49:00 2014

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required
ORA-39161: Full database jobs require privileges

报错了，主要是 hr用户没有 exp_full_database角色。

重新授予权限后，

sql> GRANT EXP_FULL_DATABASE TO hr;

问题搞定

[oracle@dbserver ~]$ expdp hr/hr directory=exp_dir dumpfile=full.dmp full=y

Export: Release 11.2.0.4.0 - Production on Fri Oct 31 17:54:42 2014

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "HR"."SYS_EXPORT_FULL_01": hr/******** directory=exp_dir dumpfile=full.dmp full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 370.1 MB
Processing object type DATABASE_EXPORT/TABLESPACE

[此贴子已经被作者于2014-10-31 18:10:19编辑过]

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)