945365 wrote:Your desktop ?
i dont have VPD and FGAC installed in my desktop.
945365 wrote:Ok, the first line shows that there is a public synonym.
here is the few rows from the above query as there are lot of rows. Please let me know if you need more rows.
PUBLIC T_GRI_RECONID_DTL_AGG_GCR 10114957 SYNONYM 26-NOV-12 26-NOV-12 2012-11-26:22:09:41 VALID N N N 1
GCRGRIT$OWNER T_GRI_RECONID_DTL_AGG_GCR GRI_1 10114668 10320109 TABLE PARTITION 26-NOV-12 28-JAN-13 2012-11-26:22:02:14 VALID N N N 1
Can you copy-paste us the result of this :
select ... FROM GCRGRIT$OWNER.t_gri_reconid_dtl_agg_gcr;
select * from all_synonyms where synonym_name='T_GRI_RECONID_DTL_AGG_GCR';
945365 wrote:Do a :
Is the database on your desktop ? (The question was if VPD or FGAC are "installed/used" in your Oracle Database no matter where it is)
i am not sure because i am working as a developer. Please let me know if i can check some how?
Or check your connection string +(and the definition of the TNS alias if you're using one)+
select host_name from v$instance;