RE: granting sys objects with grant option in 11.2.0.3 the grant option has no effect
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-lReceived on Tue Feb 21 2012 - 11:01:27 CST