Originally posted by: SystemAdmin

Using the DBID I am able to generate trees from queries and use the mdq file successfully for select statements within maps. I am not able to generate tree using the 'Generate tree from table' method.

Now, using a different ID/PW that has more privs I can generate trees from Queries, Stored Procedures and Tables. The ID I need to use here is not able to generate trees from Tables as stated above.

The message I get from the DBID is....

'The database does not have any tables...'

Are there specific privs a user must have to resolve the issue?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Did you try changing the setting that says "access user tables/procedures only" ?

This is found in the Database properties in the DBID.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

set to 'No' and it works. I'll need to look at this more now. Thanks....
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Out of interest did you perform the GRANT SYNONYM command on the database table to allow other users to view the tables?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender