Solved

What to set OS_AUTHENT_PREFIX  to null

Posted on 2007-11-24
2
1,683 Views
Last Modified: 2013-12-19
I trying to set OPS$ to null.  Is it :
os_authent_prefix=NULL
or
os_authent_prefix=’NULL’
or
os_authent_prefix=””
in the init.ora file?
I have both 9i and 10g databases
Thanks


0
Comment
Question by:Jack Seaman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Jinesh Kamdar earned 250 total points
ID: 20343063
I guess it should be OS_AUTHENT_PREFIX="OPS$"

http://www.experts-exchange.com/Database/Oracle/Q_20029490.html
0
 
LVL 11

Assisted Solution

by:Akenathon
Akenathon earned 250 total points
ID: 20346883
It's os_authent_prefix=""

Just FYI: if you are trying to connect with a Windows user authenticated by a domain, you'll have to create users named "domain\user". If you don't change the prefix, you have to create them as "ops$domain\user" :-)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question