Re: Keeping users out

On Mon, Nov 23, 2009 at 11:22 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:

> You can run the maintenance in restricted session and grant those users
> restricted session privilege.
>
>
>
If this is an E-Business Suite environment then this won't work since EBS
users do not have database level accounts.   Their accounts are maintained
by the application and stored in FND tables.

For us the easiest method is to use the fnd_user_pkg to disable/enable
accounts in R12:

fnd_user_pkg.enableuser('USERNAME');
fnd_user_pkg.disableuser('USERNAME');

We don't have alot of users, so this is pretty simple and quick.  Even if
you have a large number of users it would be pretty easy to write some
dynamic sql to put the usernames out of FND_USERS to disable the accounts
and enable the few that require access.   I believe doing this may affect
workflow and concurrent requests submitted by the user, so you'll have to
look at your particular environment to make sure this won't cause issues.

In 11i we used to just rename the login html files (ICXINDEX*.htm) under
$OA_HTML/US and provide the users who required access the new URL. In the
later stages of 11i, once the switch to AppsLocalLogin.jsp this wasn't
effective.

Other related posts: