ORA-01720: grant option does not exist
I have created a view in custom schema based on GL.GL_DAILY_RATES and some other tables ..
for all these tables i have given ALL provilages with grant option ot that schema .. but when i try to give grant all option to other schema for this view its giving error
ORA-01720: grant option does not exist for 'GL.GL_DAILY_RATES'
Am i missing any thing ?
Thanks,
Raj P