Oracle RDBMS table access
Brian Schalme
Brian_Schalme@mbnet.mb.ca
Wed, 19 Jan 2000 11:02:19 -0600
Blue:
Check to see what Oracle user name you are using, the roles/privileges
granted to that user, and the synonyms setup for that user. You may need
to do grant read privileges on the SYS table/view (such as
ALL_TAB_COLUMNS) to the user name you are using.
Brian Schalme
Airspeed Consulting
bschalme@mbnet.mb.ca
"Robert J.M. Edis" wrote:
>
> G'day all
>
> I can use PH to access data tables in an Oracle 7.3.4 database but not the
> 'special' tables such as all_tab_columns. Why?
>
> Blue
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.