Re: SYS not able to GRANT -- Strange !

Granting Object Privileges on Behalf of the Object Owner : The system privilege named GRANT ANY OBJECT PRIVILEGE allows you to grant object privileges as if you were the owner. However this a new feature in Oracle 9i release 2

Till then to grant an object privilege, you must fulfill one of the following conditions:
*You own the object specified.
* The WITH GRANT OPTION clause was specified when you were granted the object privilege by its owner.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 09:34

: 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).

:

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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).