EXP-00079: Data in table "string" is protected. Conventional path may only be exporting partial table.

EXP-00079: Data in table "string" is protected. Conventional path may only be exporting partial table.
Cause: User without the execute privilege on DBMS_RLS, the access control package, tries to export a table that has access control. Since table owner is also subjected to access control, the owner may not be able to export all rows in the table, but only the ones he can see. Also, to preserve integrity of the table, user exporting the table should have enough privilege to recreate the table with the security policies at import time. Therefore, it is strongly recommended the database administrator should be handling exporting of this table. Granting the table owner execute privilege would also satisfy this security check, though it might have other security implications. If the table does not have objects, can use direct mode.
Action: Ask the database administrator to export/import this table/view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:47

EXP-00079：表“ 字符串 ”中的数据受保护。常规路径只能导出部分表。,
.原因：没有访问控制包DBMS_RLS的execute特权的用户尝试导出具有访问控制的表。由于表所有者也受到访问控制，所有者可能无法导出表中的所有行，而只能导出他可以看到的所有行。此外，为了保留表的完整性，导出表的用户应该有足够的权限在导入时使用安全策略重新创建表。因此，强烈建议数据库管理员处理此表的导出。授予表所有者执行特权也将满足此安全检查，但它可能具有其他安全性含义。如果表中没有对象，可以使用直接模式。,
.操作：请求数据库管理员导出/导入此表/视图。,
.

aiaiDBA

13718043309

010-86462881

EXP-00079: Data in table "string" is protected. Conventional path may only be exporting partial table.

1 个回答

相似问题