SYS not able to GRANT -- Strange !

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Thu, 12 Jun 2003 20:21:47 -0700
Message-ID: <F001.005B0E21.20030612200441@fatcity.com>

Guys,

CONNECT SYS AS SYSDBA;

        create user testuser1 identified by testuser1 ;
        grant connect, resource to testuser1;

        create user testuser2 identified by testuser2 ;
        grant create session to testuser2;

        create table testuser1.table1 ( a int ) ;

        grant select on testuser1.table1 to testuser2;
        error at line 1:
        ora-01031: insufficient privileges

WHERE AS : connect testuser1/testuser1;

grant select on testuser1.table1 to testuser2;

grant succeeded.

why is it so ?
why sys is not able to GRANT ?
seems to be strange !

the env. is 8.1.6.0./win2k.

Jp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Prem Khanna J
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 12 2003 - 22:21:47 CDT