Home » RDBMS Server » Security » os password authentication (oracle 9i os ibm-aix 5.3)
os password authentication [message #526434] Tue, 11 October 2011 01:40 Go to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
hi



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

Re: os password authentication [message #526436 is a reply to message #526434] Tue, 11 October 2011 01:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
orcl> create user OPS$USER identified externally;

User created.
Re: os password authentication [message #532486 is a reply to message #526436] Wed, 23 November 2011 01:40 Go to previous messageGo to next message
skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan
Member

John Watson wrote on Tue, 11 October 2011 11:53
orcl> create user OPS$USER identified externally;

User created.



how to connect then after creating such os user?
Re: os password authentication [message #532488 is a reply to message #532486] Wed, 23 November 2011 01:44 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Easily!
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> 
Re: os password authentication [message #532503 is a reply to message #532488] Wed, 23 November 2011 03:09 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: os password authentication [message #532512 is a reply to message #532488] Wed, 23 November 2011 03:31 Go to previous messageGo to next message
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
Re: os password authentication [message #532513 is a reply to message #532512] Wed, 23 November 2011 03:33 Go to previous messageGo to next message
skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan
Member

also how on toad and oracle form's login window.
Re: os password authentication [message #532514 is a reply to message #532503] Wed, 23 November 2011 03:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: os password authentication [message #532518 is a reply to message #532515] Wed, 23 November 2011 03:43 Go to previous message
skamransajjad
Messages: 42
Registered: December 2008
Location: Pakistan
Member

@John Watson :):):):):):)Smile
Previous Topic: I have forgot my password
Next Topic: Set the EXCLUSIVE to REMOTE_LOGIN_PASSWORD
Goto Forum:
  


Current Time: Thu Mar 28 10:11:20 CDT 2024