Hi Lorne, How's it going in Comox.
I'm a UVIC grad. My gramma lives in Comox...
Ski much at washington?
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only