Re: Strange output
From: Mir M. Mirhashimali <mhyder_at_rice.edu>
Date: Tue, 29 Apr 2008 15:07:50 -0500
Message-ID: <48178016.2030408@rice.edu>
Date: Tue, 29 Apr 2008 15:07:50 -0500
Message-ID: <48178016.2030408@rice.edu>
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:Received on Tue Apr 29 2008 - 15:07:50 CDT
> 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_at_rice.edu]
> 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