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
Leave a Reply