Re: isqlplus 10g

From: disco master <harish.pond_at_gmail.com>
Date: Wed, 12 Dec 2007 00:49:52 -0800 (PST)
Message-ID: <edc1eb0c-d63e-4026-9987-4a5d1c352db0@d27g2000prf.googlegroups.com>

On Dec 11, 9:17 pm, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
> disco master <harish.p..._at_gmail.com> wrote:
> > i am unable to connect to isqlplus
>
> > when i entered
> > usr sys as sysdba
> > pwd ****
> > conn identifer : db3 ( database name)
>
> > its throwing error as
> > SP2-0306 - Invalid option. Usage: CONN[ECT] username/
> > password[@connect_identifier] [AS {SYSOPER|SYSDBA}] or: CONN[ECT] /
> > [@connect_identifier] AS {SYSOPER|SYSDBA
>
> You have to enable DBA access:
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.ht...
>
> and use the URL with "/dba" appended.
>
> Yours,
> Laurenz Albe

hi Albe
CAn you tell me what are the actual commands to create users and grant webdba role to those users and access isqlplus

thank you
from
Harish Received on Wed Dec 12 2007 - 02:49:52 CST