Re: Still OS Authentication

Let me cut-and-paste from the manual and you try this again:

"The following command creates a user who is identified by Oracle and authenti-cated by the operating system or a network service: CREATE USER scott IDENTIFIED EXTERNALLY;

The text of the OS_AUTHENT_PREFIX parameter is case-sensitive on some operating systems. "

Note also if you change the prefix then you need to recreate all the schema and tables again.

Roger Westbrook wrote:
>
> I presented this problem earlier and got some great responses but I'm
> still not able to authenticate via the OS.
>
> Allow me to elaborate a little further...
>
> We are running Oracle 7.3.4 on AIX 4.1.5
>
> I added the line "os_authent_prefix=OPS$" to my initTEST.ora parameter
> file.
> I restarted the instance.
> I created a new Oracle user with the following syntax..
> create user OPS$user identified externally;
 

-- 

Peter Teoh
Oracle Certified Professional