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?