OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » OS authentication

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OS authentication [message #297824]

Sun, 03 February 2008 22:58

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi,

I have the following parameters set in init<sid>.ora

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

sqlplus /

How is this possible?

Thanks.

Report message to a moderator

Re: OS authentication [message #297837 is a reply to message #297824]

Sun, 03 February 2008 23:15

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

This means that OS authentication is not allowed,

It means that REMOTE OS authentication is not allowed.

Regards
Michel

Report message to a moderator

Re: OS authentication [message #297848 is a reply to message #297837]

Mon, 04 February 2008 00:03

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi Michel,

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

Code: [Select all] [Show/ hide]

sqlplus /

sql>show user
OPS$ORACLE

Thanks.

Report message to a moderator

Re: OS authentication [message #297861 is a reply to message #297848]

Mon, 04 February 2008 01:02

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes but this is a LOCAL connection.

Regards
Michel

Report message to a moderator

Re: OS authentication [message #297865 is a reply to message #297824]

Mon, 04 February 2008 01:14

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.

Code: [Select all] [Show/ hide]

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

Regards

Manjit Kumar [nkbhati]

Report message to a moderator

Re: OS authentication [message #297870 is a reply to message #297865]

Mon, 04 February 2008 01:23

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Concepts
Chapter 20 Database Security
Section Overview of Authentication Methods

Regards
Michel

Report message to a moderator

Re: OS authentication [message #297988 is a reply to message #297870]

Mon, 04 February 2008 07:47

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.

Report message to a moderator

Re: OS authentication [message #297994 is a reply to message #297988]

Mon, 04 February 2008 08:06

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Do a google search on the term. Nearly 6000 results

Report message to a moderator

Re: OS authentication [message #297997 is a reply to message #297988]

Mon, 04 February 2008 08:20

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Thanks for this Michel and thanks all.
I am clearly understood.

Thanks.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 03:30:44 CDT 2025