alter system set OS_AUTHENT_PREFIX=" ";
(not taking null string)
alter system set remote_os_authent=true;
so final parameter setting is
NAME TYPE VALUE
=========================================================
remote_login_passwordfile string EXCLUSIVE
os_authent_prefix string
remote_os_authent boolean TRUE
remote_os_roles boolean FALSE
os_roles boolean FALSE
==========================================================
CREATE USER "pankajk" IDENTIFIED EXTERNALLY;
grant connect,resource to pankajk;
but when i try to connect as
sqlplus /nolog
connect /
it gives me error
ora-01017: invalid user name /password
this user pankajk is not in ORA_DBA group of WIN-XP OS
but when i am trying to set paramete OS_AUTHENT_PREFIX with null string it is giving error
SQL> alter system set OS_AUTHENT_PREFIX="";
alter system set OS_AUTHENT_PREFIX=""
ERROR at line 1:
ORA-01741: illegal zero-length identifier
Michel Cadot
Messages:
68703
Registered:
March 2007
Location:
Nanterre, France, http://...
Senior Member
Account Moderator
SQL> show parameter OS_AUTHENT_PREFIX
NAME TYPE VALUE
------------------------------------ ----------- ------
os_authent_prefix string OP$
i am trying to login as
sqlplus /
but same error
Attachment:
osuser.JPG
(Size: 49.84KB, Downloaded 1529 times)
Oracle user name is in lowercae after prefix because i created it in putting double quotes because username in OS is in lowercase
i am correct or wrong
create user "OP$pankajk" identifed externally
os username is pankajk
oracle user name OP$pankajk
as OS_AUTH_PREFIX is OP$
what is wrong ?????
Michel Cadot
Messages:
68703
Registered:
March 2007
Location:
Nanterre, France, http://...
Senior Member
Account Moderator
SQL> CREATE USER op$pankajk IDENTIFIED EXTERNALLY;
SQL> grant connect,resource to opP$pankajk;
SQL> select * from all_users;
USERNAME USER_ID CREATED
------------------------------ ---------- ---------
SYS 0 29-OCT-07
SYSTEM 5 29-OCT-07
OUTLN 11 29-OCT-07
DBSNMP 19 29-OCT-07
WMSYS 21 29-OCT-07
RMAN 23 29-OCT-07
OP$PANKAJK 27 20-NOV-07
again same error ORA-01017
Michel Cadot
Messages:
68703
Registered:
March 2007
Location:
Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot
Messages:
68703
Registered:
March 2007
Location:
Nanterre, France, http://...
Senior Member
Account Moderator
Either add the domain to your username as it is.
Or execute regedit and add the value OSAUTH_PREFIX_DOMAIN=FALSE to the key HKLM\Software\ORACLE\<your Oracle home name>.
Regards
Michel
That registry entry does not exist (OSAUTH_PREFIX_DOMAIN)
(FILE ATTACHED)
will i create that entry ???
Also i created user as
USERNAME USER_ID CREATED
------------------------------ ---------- ---------
OP$SBIN-CDC-ORCLPANKAJK 30 20-NOV-07
but still same error
Michel Cadot
Messages:
68703
Registered:
March 2007
Location:
Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes, you have to create the entry
2/ 'OP$SBIN-CDC-ORCLPANKAJK' <> OPS$||upper('SBIN-CDC-ORCL\pankajk')
Regards
Michel
it works i create user as prefix||uppercase(domainname/username)
