haven't tried it with SYS but in 9i SYSTEM (maybe any account with DBA privs -- have to try it) can definitely grant privileges on other owner's objects.
Makes my scripts that have to pass through a hosting company easy now... they have the system password, and I don't have to tell anyone the schema owner password Rachel --- Joe Testa <[EMAIL PROTECTED]> wrote: > 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). __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
