Re: sysdba role in script

From: <bofh1234_at_hotmail.com>
Date: 8 Feb 2007 09:43:12 -0800
Message-ID: <1170956592.916845.287500@s48g2000cws.googlegroups.com>

On Feb 7, 4:55 pm, "saa..._at_gmail.com" <saa..._at_gmail.com> wrote:
> Dude, did you try after granting "dba" instead of "sysdba"? If you
> notice closely, you are granting the user "sysdba" but while
> connecting, you are not conning "as sysdba"!! Thats why it is
> preferred to grant dba instead of sysdba, provided that there are no
> security constraints.
> Please let us know if that works.
>
> Saad

Saad,

You are correct. My fingers are faster than my brain. Putting in dba instead of sysdba fixes the problem. It is always these stupid little mistakes that get me. Maybe I should cut back on the caffeine :)

Thanks, Received on Thu Feb 08 2007 - 11:43:12 CST