Re: HOW TO BYPASS FINE-GRAINED Security Enforcement !!!

Thank you very much !!!

Regards Djuro.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1018878659.16473.0.nnrp-08.9e984b29_at_news.demon.co.uk...
>
>
> I didn't think this is available in 8.1.7, but in 9.0.1
> you should find lines like the following in your sql.bsq,
> which means the privilege ought to be available when
> you create the database.
>
>
> insert into SYSTEM_PRIVILEGE_MAP values (
> -235, 'EXEMPT ACCESS POLICY', 0
> );
>
>
> Perhaps you've had a problem somewhere in
> upgrading from an earlier version to a 9.0.1 version.
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Next Seminar - Australia - July/August
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
> Đuro Dretvić wrote in message ...
> >HELLO TO ALL !!!
> >
> >Platform: Windows 2000 Server
> >Oracle DB: 8.1.7.3
> >
> >METALINK:
> >The system privilege EXEMPT ACCESS POLICY allows a user to be exempted
from
> >all
> >fine-grained access control policies on any DML operation such as SELECT,
> >INSERT, UPDATE, and DELETE.
> >
> >PROBLEM:
> >
> >I can not find this system privilege on RDBMS 8.1.7.3. or RDBMS 9.1.1.3.
> >
> >Is there some package that I have to run or something ???
> >
> >
> >With regards Djuro.
> >
> >
> >
> >
>
>
Received on Mon Apr 15 2002 - 09:13:23 CDT