Re: security without using different usernames

Hi Don,

I guess you are probably on 9i which uses SPFILE so you will need to stop and start the database with

startup pfile=/location_of_your_file/init.ora

you can then migrate the init.ora parameters to the spfile for the instance. Issue the following command:

create spfile from pfile='/path_to_init_ora/init.ora';

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.