ORA-01720: grant option does not exist for 'SYS.DUAL' [message #391211] |
Wed, 11 March 2009 08:04 |
sundarfaq
Messages: 235 Registered: October 2007 Location: Chennai
|
Senior Member |
|
|
Hi,
i have created bus_ui_v view in one user i.e master. i given insert,update,delete privilage to other user.i.e slave.i got the ORA-01720: grant option does not exist for 'SYS.DUAL' error for doing this.
scripts:
create or replace view bus_ui_v
as
select 1 as ticket
from dual;
grant insert.update,delete on bus_ui_v to slave.
ORA-01720: grant option does not exist for 'SYS.DUAL'
please give me the your suggestion
|
|
|
|
|
|
|
Re: ORA-01720: grant option does not exist for 'SYS.DUAL' [message #391234 is a reply to message #391211] |
Wed, 11 March 2009 09:17 |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Normally a user can not grant access on one of their objects (bus_ui_v in this case) to another user if that object references other objects that belong to a third user (dual in this case as it belongs to sys).
The only way around that is to make use of WITH GRANT OPTION when granting access to the sys object.
You should read up on grants in the documentation.
That said - what is the point of this view?
And you should never grant insert/update/delete access to dual to anyone ever.
|
|
|
|
|