| os password authentication [message #526434] |
Tue, 11 October 2011 01:40  |
 |
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 #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 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: 8965
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
