Hello,
can anybody explain the following to me.
I have 2 users in my database lets say User1 and User2, each with its own schema.I create a new table while i am logged as User1 let's say Table1.
and then execute
grant select on Table1 to User2

Afterwards i log in as User2 and create a view named View2 as the following
Select * from Table1, and everything is fine.

Then , i execute the following

grant select on View2 to User1

and i get the following error :Grant Option does not exist for User1.Table1

Why does this happen ? User1 is the owner of Table1.How come i get this error message.

Thank you for your patience.Any help would be appreciated