Re: Strange output

Charles,

good to know. Didn't know this app employs FGAC.

Thanks All

--
Mir M. Mirhashimali
Oracle Systems Manager
Database Architecture, Enterprise Applications
Rice University
(713) 348 6365



Schultz, Charles wrote:

We use FAMIS as well, so I know what you mean. Except we have not put
VPD on that table.

You do have FGAC enabled, so that is why you are seeing different
rowcounts. It is "functioning as designed". =)

-----Original Message-----
From: Mir M. Mirhashimali [mailto:mhyder@xxxxxxxx] Sent: Tuesday, April 29, 2008 2:54 PM 
To: Schultz, Charles
Subject: Re: Strange output

Charles,
Yes we use Banner also, but this one is a totally different App called FAMIS. the table in question is part of a Interfaces to Banner. 

SQL> select * from dba_policies where object_name = 'FAMIS_GURFEED';
OBJECT_OWNER OBJECT_NAME POLICY_GROUP POLICY_NAME PF_OWNER PACKAGE FUNCTION SEL INS UPD DEL IDX CHK ENA STA POLICY_TYPE LON ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ --- --- --- --- --- --- --- --- ------------------------ --- FAMIS FAMIS_GURFEED SYS_DEFAULT FAMIS_GURFEED_POLICY FAMIS ORG_ID_SECURITY ORG_ID_SEC YES YES YES YES NO YES YES NO DYNAMIC NO RICE_FAMIS FAMIS_GURFEED SYS_DEFAULT FAMIS_GURFEED_POLICY FAMIS ORG_ID_SECURITY ORG_ID_SEC YES YES YES YES NO YES YES NO DYNAMIC NO 



--
http://www.freelists.org/webpage/oracle-l

Other related posts: