ORA-01720: grant option does not exist for …

Hi,

Imagine that you are creating a view:

create or replace view user1.view1


as

select a.*, b.* from user2.table1 a, user2.table2 b;


grant view1 to user3;


ORA-01720: GRANT OPTION DOES NOT EXIST FOR...

solution:

grant tables in the view with grant option:


grant select on user2.table1 to user1 with grant option;


grant select on user2.table2 to user1 with grant option;

In 12c:

drop view user1.view1;
create or replace view user1.view1
as
select a.*, b.* from user2.table1 a, user2.table2 b;

try and pray 🙂

Advertisements