Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SYS not able to GRANT -- Strange !

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US