Microsoft ASP(iSerios Access ODBC) list all libraries for a particular user within AS400
Home > IT Answers > AS/400 > Microsoft ASP(iSerios Access ODBC) list all l...
Rafael583
0 pts.
0
Q:
Microsoft ASP(iSerios Access ODBC) list all libraries for a particular user within AS400
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
ASKED: Oct 4 2005  12:10 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
ricksmith
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Pathfinder from Hawkeye has a tool in it to do what you need. Otherwise it is a complicated process.
Last Answered: Oct 4 2005  2:07 PM GMT by ricksmith   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

JPLamontre   0 pts.  |   Oct 6 2005  2:01AM GMT

try a select from qsys2.systables

the DB2-400 maintains SQL reference tables in QSYS2 collection (IE a library)

 

TomLiotta   7785 pts.  |   Nov 14 2009  1:23PM GMT

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

 
0