Tag: OS authentication
How to enable Operating System authentication on Oracle XE
OS authentication is not enabled by default in Oracle XE. To allow the use of OPS$ users, open sql plus (All Programs -> Oracle Database 10g Express Edition -> Run SQL Command Line) and run the following command:
alter system set os_authent_prefix=OPS$ scope=spfile;
Restart the DB:
shutdown immediate
Startup
To Create the OS user:
CREATE USER “OPS$DOMAIN\DOMAINUSER” PROFILE
“DEFAULT” IDENTIFIED EXTERNALLY DEFAULT
TABLESPACE [...]
Posted: September 22nd, 2008 under Oracle.
Tags: Oracle, OS authentication, XE
Comments: none
