Any oracle gurus still lurking here? I’m having a brain fart and missing something really obvious, I suspect…
Bobj UDT over Oracle 11g. Connection using warehouse login (not quite sys, but pretty close) and I can see all my tables in the dropdown. Connection using me and I’m missing a few. Can’t figure out why. I have grants and a public synonym on everything, so why am I not seeing all of them?
I have a very basic grasp on grants and synonyms. I’m not a DBA. What else should I be looking for to differentiate between the tables I can see and the ones that I can’t? If I can work out what is different, I am halfway to fixing it!
are you trying to find those synonyms from a alphabetic order? Since oracle is case sensitive they may be at the bottom if they start with lowercase characters.
one more thing: these database objects you cant find, are names of longer than 30 characters? if so there may be another problem.
Not longer than 30 chars and no, it’s not a case-sensitivity issue. I can see it all in Oracle - just not in Bob when I call up list of tables in designer. If I switch the connection in designer to use the warehouse login, I can see them in the correct place in the list and add them in. But when I switch back to a user connection, Bob gives me a table not found error.