Re: SYS not able to GRANT -- Strange !

At least it cannot until 9.2:

$ sqlplus /                                                                                 

SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jun 13 07:55:40 2003                                                                                 

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.                                                                                  

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning option
JServer Release 9.2.0.3.0 - Production
 SQL>
SQL>
SQL> grant select on scott.emp to public;  Grant succeeded.
 SQL> On 2003.06.13 06:20, Hemant K Chitale wrote: No user, not even SYS, can grant on another user's objects.

You have two options

1. Login as the owner of the object on which grants are to be provided and provide the grants
2. Create a grants package[which can give grants on specified objects] in the owner's schema, grant execute on that package to SYS or whichever DBA account you use and then use the package from SYS or the DBA account. The package runs in Owner's Rights ! Hemant
   • Prem Khanna J <[EMAIL PROTECTED]> 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.
>
>
> --
> 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).
>

Hemant K Chitale
http://hkchital.tripod.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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).