Question: How to read all modules assigned to user from the Primavera P6 EPPM database?
1. Login to ADMUSER schema and run the following query to get the user_id
select user_id from admuser.users where user_name = ?
2. Pass the User ID to the below query to get the assigned modules
select db_engine_type as MODULE_NAME FROM admuser.usereng WHERE user_id = ?