ORA-39109: Unprivileged users may not operate upon other users' schemas

最新推荐文章于 2025-01-22 22:30:55 发布

原创最新推荐文章于 2025-01-22 22:30:55 发布 · 5.8k 阅读

CC 4.0 BY-SA版权

本文介绍了解决在Oracle数据库中导出多个用户下部分表遇到的权限错误的方法。通过授予用户必要的系统权限，成功实现了数据导出。

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required

ORA-39109: Unprivileged users may not operate upon other users' schemas

1.操作语句,目标是导出多个用户下面的部份表，

SQL> select * from v$version
2 ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production

------------------------------------------------------------------

COMMAND:

expdp user/pwd directory=DUMP_DIR ESTIMATE=STATISTICS LOGFILE=001.log dumpfile=010.dmp parfile=02.par

[oracle@GXDB1] $vi 02.par
"02.par" 5 lines, 76 characters
schemas=FDCK,FDCZM,FDCZ
include=table:"in (
'CC_CLUSTER',
'FF_IFMI'
)"

----------------------

soluation:

GRANT RESUMABLE TO UHG_TEST;
GRANT BACKUP ANY TABLE TO UHG_TEST;
GRANT EXECUTE ANY TYPE TO UHG_TEST;
GRANT SELECT ANY TABLE TO UHG_TEST;
GRANT READ ANY FILE GROUP TO UHG_TEST;
GRANT SELECT ANY SEQUENCE TO UHG_TEST;
GRANT EXECUTE ANY PROCEDURE TO UHG_TEST;
BEGIN
SYS.DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE
(GRANTEE_NAME => 'UHG_TEST',
PRIVILEGE_NAME => 'ADMINISTER_RESOURCE_MANAGER',
ADMIN_OPTION => FALSE);
END;
/

grant EXP_FULL_DATABASE ***--不要忘记这个。。