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

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.

>

>

>

>