Re: insufficient privilege error even with SYS login

Tanel,

You are right. I failed to do it because I logged SCOTT with SYSDBA. It worked when I try logon SCOTT with Normal instead of SYSDBA.

Thank you for your help.

Howard

"Tanel Põder" wrote:

> You have to log on as user X if you want to grant any object privileges in X
> schema.
> This is a Oracle restriction, so log on as SCOTT.
>
> Tanel.
>
> "Howard" <haihuo_at_muze.com> wrote in message
> news:3ADCB280.AC671D09_at_muze.com...
> > here is the situation:
> >
> > Windows NT4.0 Server SP6
> > login on NT as local adminintrator
> > install Oralce 81
> > logon Oracle DBA Studio with SYS DBA
> >
> > try to assign SELECT SCOTT.EMP privilege to user BLAKE will get an error
> > message saying that insufficient privilege.
> >
> > any help is very appreciated.
> >
> > Howard.
> >
> >
> >
Received on Thu Apr 19 2001 - 18:36:32 CEST