How to read all modules assigned to user from Primavera P6 EPPM database

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 = ?