Security

OS authentication to access a database

User Rating:  / 0
PoorBest 
Parent Category: Articles
Created on Thursday, 18 March 2010 21:28
Last Updated on Monday, 12 March 2012 13:54
Published on Thursday, 18 March 2010 21:28
Written by Guy Lambregts
Hits: 3554

OS Authentication

 

 

How to enable OS authentication on Windows

 


SQL> show parameter os_

NAME                                 TYPE        VALUE


optimizer_index_cost_adj             integer     25
os_authent_prefix                    string
os_roles                             boolean     FALSE
remote_os_authent                    boolean     TRUE >>> mandatory : default = FALSE
remote_os_roles                      boolean     FALSE
timed_os_statistics                  integer     0
 

Create at oracle level in UPPERCASE the username

SQL> create user "MY_DOMAINE\MYSELF" identified externally temporary tablespace temp default tablespace users;

User created.
 

If you want to avoid usernames are to be prefixed by the domain


Set in the Registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<ORACLE-Registry> the entry


OSAUTH_PREFIX_DOMAIN = FALSE



SQL> create user "MYSELF" identified externally temporary tablespace temp default tablespace users;

User created.

SQL> grant create session to "MYSELF";

Grant succeeded.