Re: Help Needed - Column Security and Forms 3.0

From: Thierry Lach <tlach_at_webvisn.com>
Date: 1996/11/02
Message-ID: <01bbc74f$49af7540$0302010a_at_curlie.webvisn.com>#1/1


The reason is that the column security uses a view (offhand I don't remember which but it is one of the
ALL_% system views) which does not perform very efficiently and performs a full table scan of OBJ$.

John Clarke <johnc_at_emis.co.uk> wrote in article <01bbc5c2$af918ee0$748d9fc2_at_emis116.emis.co.uk>...
> I have successfully enforced column level security and set the 'column
 sec'
> block characteristic (forms 3.0) on a couple of forms that front end
> relevant tables. When up and running, the whole thing works as desired.
> However, there has been a big impact on the invocation time for each
 form.
> One form in particular took less than 2 seconds to load before enforcing
> column level security, but now takes over a minute!
>
> ....
>
Received on Sat Nov 02 1996 - 00:00:00 CET

Original text of this message