Grant option does not exist

[scorpio]

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

[ebrian]

Did you grant WITH GRANT OPTION?

[citldba]

I had exactly this problem the other day. It seems that if you are granting access to view2, you are also effectively granting access to the underlying table (table1).

In order to grant the access to table1, you need to have been granted access to it WITH GRANT OPTION as ebrian says.

I don't think all other RDBMS' work the same as this - but that is how Oracle does it