Re: View on a table of another user

This should work.
Without more exact error messages other than 'It doesn't work' the ng will not be able to resolve your problem.
Please post exact error messages.
Using * is _not_ recommended as views are compiled now and any change in table will force you to recreate the view.

Regards,

Sybrand Bakker, Oracle DBA

Nicolas Bronke <newsgroup_at_trinity.de> schreef in berichtnieuws 8goea6$d2m$11$1_at_news.t-online.com...
> 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