Grant create view in a schema

[OOelsner]

Hi,

I have a problem with the management of permissions.

I have UserA and UserB.

UserA owns a table T.
UserB can select the table T of UserA.

Now I want to allow UserA to create a view in
the schema of UserB.

How can I do it without using:
grant create any view to UserA

Thanks in advance
Olaf Oelsner

[sreddy]

Why do you want user-A to create view in user-B ? Any specific reason ? If user-B can select table from user-A, user-B can create view right ? (Assuming User-B has privileges to create view). Am I missing something here ?

[OOelsner]

I want that UserB is allowed to update the view of UserA.

[svk]

So, grant UserB - UPDATE priv on UserA's T. And if UserB has the create view priv, everything should be okay....

Why a view ?