Re: Apps 11i Sys Admin Advice Needed

1. To get a list of your users join FND_USER w/ dba_users and get the users that exist in FND_USER but not in DBA_USERS.
2. On the main screen, go to Security->User->Define, on the Define form, perform a search for a user to add responsibilities to, or just press the Flashlight Icon on the toolbar. Once you have found the user and pressed the OK button in the find, the user info will be loaded. You then are able to add responsibilities in the lower datagrid.
3. No, you should be able to change user passwords from the form I mentioned in #2. However, FNDCPASS is would be quicker as long as you know the userid and whether or not that userid is an Apps user or a Database User.

HTH,
Pete's

The views I may have expressed here are solely my own and not that of my employer.

Dale_at_DataBee.com (Dale Edgar) wrote in message news:<3e8ab4b4.423515903_at_news.btclick.com>...
> 1) How do I get a list of all users on the system and the
> responsibilities they have. There does not seem to be a screen for it
> in the VISION db System Administrator responsibility. I have had a
> look at FND_USER - does everybody just dig it out manually through
> joins.
>
> 2) Given I have a user, how can I give it an additional responsiblity,
> or remove a responsibility from it? Again I cannot seem to find any
> screens for this - is this a manual operation?
>
> 3) Is the only way to change the password of a user through the
> FNDCPASS utillity?
> Many thanks
> Dale
Received on Wed Apr 02 2003 - 09:05:03 CST