- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Why cannot user OS authentication in Oracle 8.1.7 ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2004 08:26 PM
тАО03-19-2004 08:26 PM
Why cannot user OS authentication in Oracle 8.1.7 ?
I created a Unix account called dbaudit and then create a corresponding Oracle account which identified externally.
However, I could not login with "sqlplus /". What's going wrong with my DB setting ??
Attached please find my init.ora file for your reference.
Appreciated for your advice.
Cheers,
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2004 09:40 PM
тАО03-19-2004 09:40 PM
Re: Why cannot user OS authentication in Oracle 8.1.7 ?
GRANT connect TO user_name;
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2004 11:24 PM
тАО03-19-2004 11:24 PM
Re: Why cannot user OS authentication in Oracle 8.1.7 ?
were you meant to say sqlplus "/ as sysdba"?
If not post the error message.
Is the user part of the dba group?
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2004 06:18 AM
тАО03-20-2004 06:18 AM
Re: Why cannot user OS authentication in Oracle 8.1.7 ?
From Metalink Note# 18088.1
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=18088.1&p_database_id=NOT
3.3) Identified Externally: --------------------------- In order for a database account to accept connections without a password the database logon must be created with an 'IDENTIFIED EXTERNALLY' clause.
Eg: CREATE USER OSUSER_SCOTT IDENTIFIED EXTERNALLY;
This will allow SCOTT to 'CONNECT /'. This will NOT allow SCOTT to connect as OSUSER_SCOTT in any other manner
CREATE USER OSUSER_SCOTT IDENTIFIED BY XYZ;
The user must supply the username AND password to connect as the account has actually been created as requiring database authentication.
Ie: 'CONNECT /'
will *NOT* work
'CONNECT OSUSER_SCOTT/XYZ'
will connect. If the OS_AUTHENT_PREFIX is set to OPS$ a user can connect in either manner if created with a password. This is more of a security risk as there are 2 ways to access the database account.
Eg: CREATE USER OPS$SCOTT IDENTIFIED BY XYZ;
Allows the user to 'CONNECT /' or 'CONNECT OPS$SCOTT/XYZ'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2004 05:17 PM
тАО03-21-2004 05:17 PM
Re: Why cannot user OS authentication in Oracle 8.1.7 ?
i believe the missing parameter is in your init.ora.
Modify it to:
os_authent_prefix = "ops$"
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2004 08:19 PM
тАО03-21-2004 08:19 PM
Re: Why cannot user OS authentication in Oracle 8.1.7 ?
As per the Oracle documentation:
OS_AUTHENT_PREFIX specifies a prefix that Oracle uses to authenticate users attempting to connect to the server. Oracle concatenates the value of this parameter to the beginning of the user's operating system account name and password. When a connection request is attempted, Oracle compares the prefixed username with Oracle usernames in the database.
The default value of this parameter is OPS$ for backward compatibility with previous versions. However, you might prefer to set the prefix value to "" (a null string), thereby eliminating the addition of any prefix to operating system account names.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2004 10:50 PM
тАО03-21-2004 10:50 PM
Re: Why cannot user OS authentication in Oracle 8.1.7 ?
Add to init.ora the following strings:
os_authent_prefix = ""
remote_os_authent = TRUE
and restart the instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2004 09:05 AM
тАО03-22-2004 09:05 AM