Datamover is a very powerful tool and access to it should always be controlled especially in PRD environments. In every organization, many users switch departments, roles and responsibilities over a period of time and every once in a while, you should review the security associated with these users to confirm that they don’t have any unwanted access.

Here are couple of SQLs that can help you understand the security associated with datamover access.

SQL1 : This SQL will give the list of users who have access to Data Mover.

SELECT DISTINCT ROLEUSER
FROM PSROLEUSER A
WHERE A.ROLENAME IN
(SELECT DISTINCT ROLENAME
FROM PSROLECLASS A,
PSAUTHITEM B
WHERE A.CLASSID IN
(SELECT DISTINCT CLASSID FROM psauthitem WHERE MENUNAME=’DATA_MOVER’
)
);

You should carefully review this list and remove any unwanted access.

Read Further:http://peoplesofttutorial.com/quickly-find-users-who-have-access-to...