Search This Blog


Oracle 9i Oracle Policy Manager

Oracle Policy Manager allows fine grain control on what user can SELECT from any table. During table export, user will see following warning

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

There are 2 solutions:
  1. Temporary disable policy
  2. Use user with system privilege EXEMPT ACCESS POLICY (SYS, but not SYSTEM)

No comments: