Wednesday, May 9, 2012

After enabling Label Security SQL developer shows ORA-00904: "ORA_ROWSCN": invalid identifier

Problem Description
The use of ORA_ROWSCN is not compatible with Fine Grained Access policies (either dbms_rls or OLS).

When connecting to DB 10.1 or > 11g using SQL Developer 3.0 or 2.0, and choosing any specific table on the left side, the "Details" tab on the right hand pane throws ORA-904. This happens only with 10gR1 Database (10.1.x) and later version. It works fine for other older versions of Database.

Cause of the Problem
This is SQL Developer bug.

Solution of the Problem
Analyze the table and its structure.

a. Analyze table tablename validate structure

Check if you can disable the use of this pseudo column in sql developer, this seems to be possible
under Tools --> Preferences --> Database --> ObjectViewer. other versions of sql developer may not use this also.

Once you disable the use of ORA_ROWSCN in sql developer you can now access the tables data without any problem.

No comments: