Well, this seems kind of elementary unless I'm missing something. SI uses a database like Oracle or SQL Server, right? Just track down the username and password you used to for the installation to access the database, start up SQLPlus or SQL Server enterprise manager (or whatever your version calls it) and go poke around.
Mike ----------------------------------------- Michael C. Rawlins, Senior Software Engineer, GXS Sent from personal account On 1/7/2013 12:26 PM, L wrote: > > This begs a general question regarding SI 5.2. How does one find a > list of table names and the fields contained therein? > > Thank you, > Lori Folta > Lead EDI Engineer > UniGroup > > --- In [email protected] <mailto:EDI-L%40yahoogroups.com>, riaz > mohammed wrote: > > > > YFS_USER > > > > > > > > ________________________________ > > From: Vijay Chandra > > To: "[email protected] <mailto:EDI-L%40yahoogroups.com>" > > Sent: Wednesday, January 2, 2013 11:17 PM > > Subject: [EDI-L] Generate report on User information(IBM Sterling > Integrator 5.2) > > > > Â > > Hi All, > > > > Can anyone please share the Database table names that store all User > names and their corresponding details like permissions of that User. I > need to generate a report on user permissions and found out that there > is no pre-defined report configuration for fetching User information. > The only way is to extract the values from Database. > > > > I am using IBM Sterling Integrator 5.2. > > > > [Non-text portions of this message have been removed] > > > > > > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
