From jo_holvoet@amis.com Fri, 13 Jun 2003 01:54:58 -0700 From: jo_holvoet@amis.com Date: Fri, 13 Jun 2003 01:54:58 -0700 Subject: Re: SYS not able to GRANT -- Strange ! Message-ID: MIME-Version: 1.0 Content-Type: text/plain There's a new sys priv in 9i called "grant any object privilege" that can be used for this. regards Jo Joe Testa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/13/2003 06:34 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: SYS not able to GRANT -- Strange ! its always been that way, its not strange, sys has NEVER been able to grant privs on other owner's objects. i think that has changed in 9i but its late and my brain is fuzzy. joe Prem Khanna J wrote: >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. > > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: 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).