Troubleshooting RLS

RLS is a complex feature that interacts with a variety of elements in the Oracle architecture. You may encounter errors, either as a result of problems in your design or through misuse by users. Fortunately, for most errors, RLS produces a detailed trace file in the directory specified by the database initialization parameter USER_DUMP_DEST. This section describes how you can trace RLS operations and resolve error conditions.

Upgrade Strategy for Oracle Database 10g Policy Types

When upgrading from Oracle9i Database to Oracle Database 10g, I recommend that you do the following:

  1. Initially use the default type (dynamic).

  2. Once the upgrade is complete, try to re-create the policy as context-sensitive and test the results thoroughly, with all possible scenarios, to eliminate any potential caching issues.

  3. Finally, for those policies that can be made static, convert them to static and test thoroughly.

Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial