View on a table of another user

How can I create a view on table(owner is another user). Although I have allrights granted it looks as to be impossible.

e.g. User1 wants to create

create view user1.viewname as select * from user2.tablename

Any suggestions?

Regards

Nicolas Received on Sat May 27 2000 - 00:00:00 CDT