I have created a user account TEMP1 and I have granted to this user a role called CARD_READONLY. This role has the privilege of selecting a set of tables at remote database via dblink.
Logging in as TEMP1, I can do the select command on all the tables under role CARD_READONLY, but when I try to use the describe command to show the structure of one of the tables, the database shows error: table xxx not found.
Can you help me to figure out the reason behind?
There was a bug (number 763958) from 8.0.5 days that exhibited this behavior but was fixed in 8.1.7 to the best of my knowledge. You didn't indicate which version of the database you were running, but it sure sounds like this bug.
Dig Deeper on Oracle error messages
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.