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