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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement