Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdba role in script
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