I have a requirement in my organization that a password restriction have to be implemented. After implementing that, for some users, the password date will have to be nulled out, so that when they login, they will be forced to change their password following that new password rule.Use the same update statement in $FND_TOP/sql/AFCPEXPIRE.sql and include/exclude the usernames you want.
Oracle's "CP SQL*Plus Expire FND_USER Passwords" concurrent program can not be used as that will expire all the users password at the same time.
For this, I have to find all the users which have a certain responsibility (check viewing responsibility) and only that responsibility. First day password date null out will be implemented for them only. For the other users (who have check printing responsibility) the password will be nulled out some other day.See (How To Find Out Which Responsibility Was Granted To A Specific User? [ID 304687.1]).
As I am using the following query, I see some of the users have multiple responsibility. How do I find out the users who have only a certain responsibility and nothing else?
select usr.user_name, res.responsibility_nameTry this query ..
from apps.fnd_user usr, apps.FND_USER_RESP_GROUPS_DIRECT usrrep, apps.fnd_responsibility_tl res
and usr.end_date is NULL
group by usr.user_name,res.responsibility_name
SQL> select fu.user_name, count(frvl.responsibility_name) from fnd_user_resp_groups_direct furgd, fnd_responsibility_vl frvl, fnd_user fu where furgd.responsibility_id = frvl.responsibility_id and fu.user_id = furgd.user_id and (to_char(furgd.end_date) is null or furgd.end_date > sysdate) group by fu.user_name having count(frvl.responsibility_name) = 1;