It's a weird question and I think I kow the answer but wanted someone to confirm.
When I create a user in CMOD, does it create a database (ORACLE or DB2) user internally?
Or it just maintains this information in some CMOD table and internally uses the super user ID to fire the queries?
Users are created in the arsuser table, and access is granted based on group membership and permissions.
-JD.
How do I get a list of OnDemand Userids and Usernames? I don't see a way to do this from the Admin GUI so I am guessing that I need to do a DB2 select of some sort, right? Does anyone have an example?
You can go into the Admin Client, log on to the server, and under the 'User' Section, select individual users (Control-Click) or a range of users (Click first user, then shift-click last user), then right-click on one of the selected users, and choose "Report".
You'll be prompted for the specifics of the report, and where you'd like it to be saved.
Hope that helps!
-JD.