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

Last updated on FEBRUARY 08, 2023

Applies to:

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 xx default tablespace users;
create user u2 identified by xx default tablespace users;
create user u3 identified by xx default tablespace users;
grant dba to u1;
grant dba to u2;
grant connect, resource to u3;
connect u2/xx
create table tview (col1 number, col2 number);
grant select on tview to u1 with grant option;
connect u1/xx
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>

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.