Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error using describe command

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close