Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i FGA

Re: Oracle 9i FGA

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 18 May 2006 22:03:03 +0800
Message-ID: <446C7E97.793B@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US