Re: Help Needed - Column Security and Forms 3.0
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
John Clarke <johnc_at_emis.co.uk> wrote in article
<01bbc5c2$af918ee0$748d9fc2_at_emis116.emis.co.uk>...
ALL_% system views) which does not perform very efficiently and performs a
full table scan of OBJ$.
> 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