How to set Parameter SQL92_SECURITY  = TRUE

Posted on 2006-06-07
Last Modified: 2013-12-11
I need to set SQL92_SECURITY  = TRUE. It is currently set to false. I added SQL92_SECURITY  = TRUE to the initsid.ora file. I shutdown the database and started it up again. However, when I run the following statement it is still showing the value to be false:


Could someone please provide step by step instructions on how to set this parameter?

Question by:sikyala
    LVL 2

    Accepted Solution

    You may have added it to the initSID.ora parameter file, but your database may be using an SPFILE.
    Incase you have nit recreated the SPFILE, please use the following commands to recreate:

    create spfile from pfile;

    And you will see the parameter is now effective.


    Author Comment

    Everything worked fine. I was wondering if this new setting would cause any adverse affects on the database?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now