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.