I thought it might be a perrmision problem, so I put select rights directly to the user, no change. I have all the rights in a role as well. All table and view names are uppercase, so that is no problem. Logging in as the user, the SELECT part works well, Logging in as INTERNAL, SYS or SYSTEM seems to make no difference, the CREATE OR REPLCAE VIEW returns "Table or view does not exist"

>Hi Lorne, How's it going in Comox.
Good, but am unemployed at end of month

>I'm a UVIC grad. My gramma lives in Comox...
>Ski much at washington?

Don't ski at all, I hate snow
>
>I think it's either...
>
>a) A permissions problem..
>
>I had a similar problem with a Stored procedure.
>It had something like
>
>select xyz from sysadm.styles where ....
>
>in it and I was creating it under user lingerie.
>
>I had to login as sysadm
>and do...
>grant select,insert,update,delete on styles to lingerie;
>
>What I noticed is that if I grant to the role instead it did not work..
>
>Anyways try granting select on the Master table to the user..
>
>b)Maybe the table itself is named in lower or upper case.
>This happened once when I used the VFP upsizer...
>
>Usually on oracle all names are upper case in the data dictionary...
>But some tables were lower case you can see it if you query
>select table_name from user_tables;
>
>It's either called "master" or "MASTER".
>
>Then either:
>create "MASTER" as select * from "master";
>and then drop "master"
>
>HTH
>Get the point?