Security
OS authentication to access a database
User Rating: / 0
- Details
-
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: 3581
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.