1 Reply Latest reply on May 21, 2019 8:25 PM by Emad Al-Mousa

    Oracle VPD issue

    3739561

      DB 11.2.0.4

      OS: Solaris 10 sparc

       

      Appied VPD on a table SCHEMA1.TABLE1 and enabled.

       

      from server sqlplus (login with USER1):

      USER1@UAT> select count(*) from SCHEMA1.TABLE1;

        COUNT(*)
      ----------
             679

       

      from sqldeveloper (login with USER1 too)

      select count(*) from SCHEMA1.TABLE1;

        COUNT(*)
      ----------
             40001

       

      any idea why the count(*) result are diff ?