Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SYS not able to GRANT -- Strange !

Re: SYS not able to GRANT -- Strange !

From: <bulbultyagi_at_now-india.net.in>
Date: Mon, 16 Jun 2003 18:16:32 -0700
Message-ID: <F001.005B2817.20030616165919@fatcity.com>


Granting Object Privileges on Behalf of the Object Owner : The system privilege named GRANT ANY OBJECT PRIVILEGE allows you to grant object privileges as if you were the owner. However this a new feature in Oracle 9i release 2

Till then to grant an object privilege, you must fulfill one of the following conditions:
*You own the object specified.
* The WITH GRANT OPTION clause was specified when you were granted the object privilege by its owner.

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

:

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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 Mon Jun 16 2003 - 20:16:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US