ORA-39181: Only partial table data may be exported due to fine grain access control on string

ORA-39181: Only partial table data may be exported due to fine grain access control on string
Cause: An unprivileged user has tried to export a table that has fine grain access control. The table owner is subjected to access control and may not be able to export all rows in the table. Only the rows that can be seen by that user will be exported. In order to preserve integrity of the table, the user importing the table should have enough privilege to recreate the table with the security policies at import time.
Action: It is strongly recommended that the database administrator handle exporting of this table.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-39181：由于对字符串的精细访问控制，只能导出部分表数据,
.原因：非特权用户已尝试导出具有精细访问控制的表。表所有者受到访问控制，并且可能无法导出表中的所有行。只有该用户可以看到的行才会被导出。为了保留表的完整性，导入表的用户应该有足够的权限在导入时使用安全策略重新创建表。,
.操作：强烈建议数据库管理员处理此表的导出。,
.

aiaiDBA

13718043309

010-86462881

ORA-39181: Only partial table data may be exported due to fine grain access control on string

1 个回答

相似问题