Re: Oracle 9 NT Authentication "conn / as sysdba" - Role issue ?

What is: llRC

Not sure what you mean by: "> All IIRC, I would need to verify this at my work."

I have created the username for john as: MYDOMAIN\OPS$JOHN

I do not think I can user MACHINENAME\username since all NT authenticated users may login from many different computers. When I use Oracle tools to create a user it always creates the username in uppercase. Does it really have to be lowercase ?

Sybrand Bakker wrote:
> On 30 May 2006 06:43:48 -0700, "Davep"
> <davepylatuk_at_centurysystems.net> wrote:
>
> >Now I understand that I dont want to use connect / as sysdba.
> >
> >I do have an Oracle account named: OPS$JOHN but get 'insufficient
> >privileges' when
> >I am logged in to the domain as 'JOHN' and try to do: 'conn /'
> >
> >What am I missing ?
> >
> >Thanks.
>
> The default os_authent_prefix is "". Oracle recommends it leaving it
> that way.
> Your Oracle account needs to read as <MACHINENAME>\username, IIRC the
> machine name must be in uppercase, username in lowercase.
> Alternatively you could use your <DOMAIN>
> All IIRC, I would need to verify this at my work.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed May 31 2006 - 08:27:42 CDT