Microsoft ASP(iSerios Access ODBC) list all libraries for a particular user within AS400

pts.
Tags:
AS/400
how do i list all the libraries that a user has access to. the user will be login in thru a ASP (iSerios Access ODBC Driver). Is there a "table" i can "SELECT" from and/or a "command" that i can execute. and subsequently i only want to display all the "tables" that the users has created in those libraries. Please I need help -- I AM A NEWBIE in the AS400.. Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Pathfinder from Hawkeye has a tool in it to do what you need. Otherwise it is a complicated process.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JPLamontre
    try a select from qsys2.systables the DB2-400 maintains SQL reference tables in QSYS2 collection (IE a library)
    0 pointsBadges:
    report
  • TomLiotta
    I see there's been nothing useful for your question so far. Unfortunately, you'll need to clarify a couple things. What do you mean by "libraries that a user has access to"? Do you mean the set of libraries that make up the default 'path' for the user? Or do you mean the libraries to which the user has access authority? Those can be very different lists. And what do you mean by tables "that the users has created"? It's likely that the user hasn't created any tables at all. Do you only want ones actually 'created' by the user? Exclude tables that the user is only the owner of? Exclude tables that the user has existence rights over unless the user is the 'creator'? Exclude tables that the user only has 'change' rights to? Do you want all 'created' tables from all appropriate libraries in a single list? (What if the user doesn't have appropriate authority even having created the tables?) Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following