Skip to content
December 30, 2011 / doganay

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: