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).
Received on Fri Jun 13 2003 - 05:33:17 CDT
