insufficient privilege with SYS DBA

From: Howard <haihuo_at_muze.com>
Date: Wed, 18 Apr 2001 11:11:05 -0400
Message-ID: <3ADDAE89.950C2F85@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.

Here is what I tried also:

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
example , user BLAKE
5) get insufficient privilege error

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.

any help is very appreciated.

Howard. Received on Wed Apr 18 2001 - 10:11:05 CDT