Skip to content
March 9, 2011 / doganay

ORA-01720: grant option does not exist for…

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,

Probably, you get this error because of missing grants.

Well, if you want to grant to a view: view1, this view refers to table1 and table2

Schema user (owner of the view) has grant to table1 but not to table2.

So, you must grant to schema user on table2 with grant option:

grant _PRIVILEGE_ on _TABLE_ to _SCHEMA_USER_ with grant option;

or

You have a role that grants to an objects, but a procedure that you own raises an error when it is executed.
That is because of you must have that privilege yourself (schema_user: owner of the object), not inherited by role only:

grant _PRIVILEGE_ on _TABLE_ to _SCHEMA_USER_;

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: