Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i FGA
Sylvestre wrote:
>
> Hello
>
> In Oracle 10g doc, it is mentionned that we can't
> have more than 256 policies by objects,but in
> 9i there is no trace of this limit, has I have
> some problem with policies wich don't work and as
> we have 282
> policies enabled, I wander if this limit apply to
> 9i ?
>
> Thank you
easy enough to test isn't it ?
begin
for i in 1 .. 1000 loop
dbms_fga.add_...(....)
end loop;
end;
and see what happens...
-- Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable" web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald_at_yahoo.com "Semper in excremento, sole profundum qui variat." ------------------------------------------------------------Received on Thu May 18 2006 - 09:03:03 CDT