Home » RDBMS Server » Server Administration » OS authentication
OS authentication [message #297824] Sun, 03 February 2008 22:58 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,

I have the following parameters set in init<sid>.ora
os_authent_prefix = ops$
remote_os_authent = false

This means that OS authentication is not allowed, please correct me if I am wrong.

But from the UNIX user "oracle" I could execute like

sqlplus /

How is this possible?


Thanks.
Re: OS authentication [message #297837 is a reply to message #297824] Sun, 03 February 2008 23:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
This means that OS authentication is not allowed,

It means that REMOTE OS authentication is not allowed.

Regards
Michel
Re: OS authentication [message #297848 is a reply to message #297837] Mon, 04 February 2008 00:03 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Michel,

But I can able to connect from the OS user "oracle" like

sqlplus /

sql>show user
OPS$ORACLE


Thanks.
Re: OS authentication [message #297861 is a reply to message #297848] Mon, 04 February 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but this is a LOCAL connection.

Regards
Michel
Re: OS authentication [message #297865 is a reply to message #297824] Mon, 04 February 2008 01:14 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
Shahnazurs,
Oracle offers you a number of authentication mechanisms suitable for a variety of situations. You need to understand them in order to arrive on a suitable authentication scheme for you installation. DBA guide of your platform & oracle version gives a detailed explanation on various authentication options. Given below please find some pointers that may be of help in clearing ambiguities pertaining to OS authentication.

http://www.oracle-base.com/articles/misc/OsAuthentication.php


Regards

Manjit Kumar [nkbhati]

Re: OS authentication [message #297870 is a reply to message #297865] Mon, 04 February 2008 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 20 Database Security
Section Overview of Authentication Methods

Regards
Michel
Re: OS authentication [message #297988 is a reply to message #297870] Mon, 04 February 2008 07:47 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks for your reply.

Could you please tell me what is the use of REMOTE_OS_AUTHENT parameter?

Thanks.
Re: OS authentication [message #297994 is a reply to message #297988] Mon, 04 February 2008 08:06 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Do a google search on the term. Nearly 6000 results
Re: OS authentication [message #297997 is a reply to message #297988] Mon, 04 February 2008 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read what I posted? Did you read the link I posted?
What can we say in addition?

All parameters are described in Reference manual: REMOTE_OS_AUTHENT

Regards
Michel

[Updated on: Mon, 04 February 2008 08:21]

Report message to a moderator

Re: OS authentication [message #298002 is a reply to message #297997] Mon, 04 February 2008 08:45 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks for this Michel and thanks all.
I am clearly understood.

Thanks.

Previous Topic: BLOB Issue
Next Topic: copy 8i oracle software
Goto Forum:
  


Current Time: Mon Dec 05 09:13:16 CST 2016

Total time taken to generate the page: 0.09561 seconds