RE: granting sys objects with grant option in 11.2.0.3 the grant option has no effect

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Tue, 21 Feb 2012 09:01:27 -0800
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF83CACA_at_mail02.mba.xifin.com>



I am seeing the same issue for Solaris.
> sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 21 08:57:42 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning option

SYS_at_oracle> create user ttt_user identified by asdfghjk;

User created.

SYS_at_oracle> grant create session to ttt_user;

Grant succeeded.

SYS_at_oracle> grant execute on dbms_output to ttt_user with grant option;

Grant succeeded.

SYS_at_oracle> create user ttt2_user identified by asdfghjk;

User created.

SYS_at_oracle> connect ttt_user/asdfghjk Connected.
TTT_USER_at_oracle> exec dbms_output.enable;

PL/SQL procedure successfully completed.

TTT_USER_at_oracle> grant execute on sys.dbms_output to ttt2_user; grant execute on sys.dbms_output to ttt2_user

                     *

ERROR at line 1:
ORA-01031: insufficient privileges

Michael Dinh
Disparity Breaks Automation (DBA)

Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt  Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre  

-----Original Message-----
From: Kurt-Franke_at_web.de [mailto:Kurt-Franke_at_web.de] Sent: Tuesday, February 21, 2012 8:53 AM To: Michael Dinh; oracle-l
Cc: Kurt.Franke_at_cellent-fs.de; Ronald.Stiefel_at_cellent-fs.de Subject: Re: granting sys objects with grant option in 11.2.0.3 the grant option has no effect

Yes, the creation of the users and the grants are done connected with sys as sysdba

kf

-----Ursprüngliche Nachricht-----
Von: "Michael Dinh" <mdinh_at_XIFIN.Com> Gesendet: 21.02.2012 17:44:34
An: "'Kurt-Franke_at_web.de'" <Kurt-Franke_at_web.de>, oracle-l <oracle-l_at_freelists.org> Betreff: RE: granting sys objects with grant option in 11.2.0.3 the grant option has no effect

>Were you connected as SYS when executing - grant execute on dbms_output to ttt_user with grant option; ???
>
>Michael Dinh
>Disparity Breaks Automation (DBA)
>
>Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt 
>Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre

>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kurt-Franke_at_web.de
>Sent: Tuesday, February 21, 2012 6:31 AM
>To: oracle-l
>Cc: Kurt.Franke_at_cellent-fs.de; Ronald.Stiefel_at_cellent-fs.de
>Subject: FW: granting sys objects with grant option in 11.2.0.3 the grant option has no effect
>

...

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 21 2012 - 11:01:27 CST

Original text of this message