Re: insufficient privilege error even with SYS login
From: (wrong string) õder <tanel_at_altavista.kom>
Date: Thu, 19 Apr 2001 18:20:45 +0200
Message-ID: <3adf101f$0$232$ba624cac_at_news.uninet.ee>
Date: Thu, 19 Apr 2001 18:20:45 +0200
Message-ID: <3adf101f$0$232$ba624cac_at_news.uninet.ee>
You have to log on as user X if you want to grant any object privileges in X
schema.
Tanel.
"Howard" <haihuo_at_muze.com> wrote in message
news:3ADCB280.AC671D09_at_muze.com...
This is a Oracle restriction, so log on as SCOTT.
> 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:20:45 CEST