oracle imp导入要什么数据权限
1个回答
推荐于2017-05-19
展开全部
要先区别: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.
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.
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询