Oracle抽取其他数据库数据需要什么权限

Oracle抽取其他数据库数据需要什么权限

一般最高权限需要connect，resource，dba这三个即可。

语句：
grant connect,resource,dba to 用户;

权限说明：

dba：拥有全部特权，是系统最高权限，只有DBA才可以创建数据库结构。
resource：拥有Resource权限的用户只可以创建实体，不可以创建数据库结构。
connect：拥有Connect权限的用户只可以登录Oracle，不可以创建实体，不可以创建数据库结构。

要先区别：dba<>sysdba,建议使用dba操作。使用其它权限实际管理时，比较不方便。原因如oracle所述。当然决定因素：主要是由导出导入的内容所决定你需要的最小权限集。 文章显示:imp_full_database ,exp_full_database 最终都给到了dba import to use import, you need the privilege create session to log on to the oracle database server. this privilege belongs to the connect role established during database creation. you can do an import even if you did not create the export file. however, keep in mind that if the export file was created by a user with exp_full_database privilege, then you must have imp_full_database privilege to import it. both of these privileges are typically assigned to dbas. export: to use export, you must have the create session privilege on an oracle database. to export tables owned by another user, you must have the exp_full_ database role enabled. this role is granted to all dbas. if you do not have the system privileges contained in the exp_full_database role, you cannot export objects contained in another user’s schema. for example, you cannot export a table in another user’s schema, even if you created a synonym for it.