Can Not Grant Object Privileges On Behalf Of The Owner With Dba Role in 10.2.x (Doc ID 364312.1)

Last updated on APRIL 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 06-JUN-2013


Symptoms

On Oracle 9i and Oracle 10.1.x, granting select privileges to a one user from another dba user was allowed.  Starting with 10.2, you will get

Here is a test case:

drop user u1 cascade;
drop user u2 cascade;
drop user u3 cascade;

create user u1 identified by u1 default tablespace users;
create user u2 identified by u2 default tablespace users;
create user u3 identified by u3 default tablespace users;
grant dba to u1;
grant dba to u2;
grant connect, resource to u3;
connect u2/u2
create table tview (col1 number, col2 number);
grant select on tview to u1 with grant option;
connect u1/u1
create view tst_view as select * from u2.tview;
select * from tst_view;
grant select on tst_view to u3;

ORA-1720  grant option does not exist for <schema.table>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms