Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting using Olog() as sysdba
grant select on dba_users/select_catlog_role to normal_user.
connect as normal_user.
<mydevnull_at_fastmail.fm>
??????:1118021057.332115.3840_at_g49g2000cwa.googlegroups.com...
> Hi there,
>
> I am using an old 7.x library call olog() to connect to Oracle. All is
> fine except I can't connect as sysdba. Basically, I have this call:
>
> r = olog(&lda, (ub1 *) hda, buf, -1, (text *) 0, -1,
> (text *)0, -1, (ub4)OCI_LM_DEF);
>
> which works if buf is "scott/tiger_at_orcl" etc, but does Not work if buf
> is "sys/syspass_at_orcl as sysdba" .
>
> How do I connect as sysdba using olog()? I need to look inside
> dba_users and the client is on a remote machine. The targets are Oracle
> 7i, 8i, 9i, and 10i EE. I have checked that 10i doesn't allow sys
> without sysdba while 8i does.
>
> Any help will be really useful.
>
> Thanks,
> Vinay.
>
Received on Sat Jun 18 2005 - 10:24:29 CDT