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