Forum Stats

  • 3,741,431 Users
  • 2,248,428 Discussions
  • 7,861,792 Comments

Discussions

Oracle VPD issue

User_HNLOG
User_HNLOG Member Posts: 19 Red Ribbon
edited May 21, 2019 4:25PM in Database Security - General

DB 11.2.0.4

OS: Solaris 10 sparc

Appied VPD on a table SCHEMA1.TABLE1 and enabled.

from server sqlplus (login with USER1):

[email protected]AT> 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 ?

Answers

Sign In or Register to comment.