You can use FND_USER_PKG to modify a user from back end.
below is the fnd_user_pkg.removependinguser
--
-- RemovePendingUser (PUBLIC)
-- Delete this user from fnd_user table only if this is a pending user.
-- If this is not a valid username or is not a pending user, raise error.
-- Pending user is created when a user registers a user account through
-- UMX with an aproval process.
--
-- Usage example in pl/sql
-- begin fnd_user_pkg.removependinguser('SCOTT'); end;
--
-- Input (Mandatory)
-- username: User Name
--
procedure RemovePendingUser(username varchar2) is
l_user_id number;
begin
-- Added for Function Security Cache Invalidation
-- RSHEH: Need to have exception trapping for no_data_found exception
begin
select user_id into l_user_id
from fnd_user
where user_name = upper(username)
and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
exception
when no_data_found then
fnd_message.set_name('FND', 'FND_INVALID_USER');
fnd_message.set_token('USER_NAME', username);
app_exception.raise_exception;
end;
-- Only allow to delete a PENDING user
delete from fnd_user
where user_name = upper(username)
and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
if (sql%rowcount = 0) then
fnd_message.set_name('FND', 'FND_INVALID_USER');
fnd_message.set_token('USER_NAME', username);
app_exception.raise_exception;
else
-- Added for Function Security Cache Invalidation
fnd_function_security_cache.delete_user(l_user_id);
end if;
end RemovePendingUser;
i want to know ,how to delete oracle 11i application user not the database user.
e.g. i created a user from security---> define---->user
now i want to delete this ,wat steps i have to follow
regards
<i><div align="right">Originally posted by smaamirj - 03/05/2007 : 11:43:38 AM</div id="right"></i>