OraFAQ Forum: Security » os password authentication

Home » RDBMS Server » Security » os password authentication (oracle 9i os ibm-aix 5.3)

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

os password authentication [message #526434]

Tue, 11 October 2011 01:40

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

Code: [Select all] [Show/ hide]

OS_AUTNENT_PREFIX=OPS$
      create user OPS$USER identified externally by abc;
   
   following error has occured
  
 SQL>  create user OPS$USER identified by externally 123;
 create user OPS$USER identified by externally 123
                                               *
ERROR at line 1:
ORA-00922: missing or invalid option

Report message to a moderator

Re: os password authentication [message #526436 is a reply to message #526434]

Tue, 11 October 2011 01:53

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

Code: [Select all] [Show/ hide]

orcl> create user OPS$USER identified externally;

User created.

Report message to a moderator

Re: os password authentication [message #532486 is a reply to message #526436]

Wed, 23 November 2011 01:40

skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan

Member

John Watson wrote on Tue, 11 October 2011 11:53

Code: [Select all] [Show/ hide]
orcl> create user OPS$USER identified externally; User created.

how to connect then after creating such os user?

Report message to a moderator

Re: os password authentication [message #532488 is a reply to message #532486]

Wed, 23 November 2011 01:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Easily!

Code: [Select all] [Show/ hide]

STRUJA_$ sqlplus /

SQL*Plus: Release 3.1.3.5.1 - Production on Wed Nov 23 09:43:44 2011

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQLe> show user
user is "OPS$ELKOM10R"
SQLe>

Report message to a moderator

Re: os password authentication [message #532503 is a reply to message #532488]

Wed, 23 November 2011 03:09

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

SQL*Plus: Release 3.1.3.5.1

are you Still using it ?for Quote:

Release 8.1.7.0.0

Sriram

Report message to a moderator

Re: os password authentication [message #532512 is a reply to message #532488]

Wed, 23 November 2011 03:31

skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan

Member

Sorry i did not get you "littlefoot". my user name is OPS$KAMRAN, please tell me the statement

Report message to a moderator

Re: os password authentication [message #532513 is a reply to message #532512]

Wed, 23 November 2011 03:33

skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan

Member

also how on toad and oracle form's login window.

Report message to a moderator

Re: os password authentication [message #532514 is a reply to message #532503]

Wed, 23 November 2011 03:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@Sriram:
Yes; it is an advanced version. Until recently, it was Oracle 7.1.

Started in read-only mode, it supports a long time "dead" application that is used extremely rarely for archive purposes, is written in Forms 3.0 and Reports 1.2, contains hundreds of reports and forms and there's no reason to upgrade it (because it is dead).

We don't have any OPS$ users in recent database versions, so ...

@skamransajjad: The statement is

Code: [Select all] [Show/ hide]

sqlplus /

You don't need anything else. Username in my example differs from yours (which is expected; it would be quite a surprise if they were called identically).

[Updated on: Wed, 23 November 2011 03:39]

Report message to a moderator

Re: os password authentication [message #532515 is a reply to message #532513]

Wed, 23 November 2011 03:37

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

You want to us OS authentication from a remote client? In that case, you have to set your REMOTE_OS_AUTHENT instance parameter to TRUE and crate an operating system user id OPS$KAMRAN on your local PC. eYou'll need to discuss this with your DBA, who will probably say "Never in a million years will I permit this" because of the security implications.

Report message to a moderator

Re: os password authentication [message #532518 is a reply to message #532515]

Wed, 23 November 2011 03:43

skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan

Member

@John Watson :):):):):):) Smile

Report message to a moderator

Previous Topic:	I have forgot my password
Next Topic:	Set the EXCLUSIVE to REMOTE_LOGIN_PASSWORD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 21:00:01 CDT 2025