DB Tricks -->

DataBase Tips and Tricks

Main menu:


Did I save you some time? Buy me a coffee

Site search

September 2010
M T W T F S S
« Jun    
 12345
6789101112
13141516171819
20212223242526
27282930  

Categories

Tags

Blogroll

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 [...]

s