Re: insufficient privilege error even with SYS login

it doesn't work either.

Here is what I tried:

1) login DBA Studio as SYS with DBA
2) grant SCOTT with DBA role
3) login DBA Studio as SCOTT with DBA
4) grant object privilege SELECT on EMP to any existing or new user/ role, for

P.S.
I can login as SYS with DBA to grant any roles/system privilege and object privilege from most of the SYS tables without any error.

thank you for your reply.

Howard

???? ??????????? wrote:

> I think that only user "SCOTT" can grant privilege SELECT on his table EMP.
>
> Best regards, kme.
>
> "Howard" <haihuo_at_muze.com> ???????/???????? ? ???????? ?????????:
> 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 Wed Apr 18 2001 - 15:53:57 CEST