Search This Blog

2008-08-21

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: