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_