• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3189
  • Last Modified:

How to set Parameter SQL92_SECURITY = TRUE

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:

SHOW PARAMETER SQL92_SECURITY;

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

Thanks!
0
sikyala
Asked:
sikyala
1 Solution
 
shahidnsCommented:
Hi,
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:

Shutdown
create spfile from pfile;
startup

And you will see the parameter is now effective.

Regards.
Shahid.
0
 
sikyalaSenior Database AdministratorAuthor Commented:
Everything worked fine. I was wondering if this new setting would cause any adverse affects on the database?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now