|
Import data from EPFO_PDB_CLONE to PDB_DEV
|
|
|
|
select * from FO_OFFICE_USERS OU WHERE
|
|
TRIM( UPPER( OU.LOGIN_NAME )) = TRIM( UPPER( 'Front_deskdajkjammu' ));
|
|
|
|
select * from FO_OFFICE_USERS OU WHERE
|
|
TRIM( UPPER( OU.LOGIN_NAME )) = TRIM( UPPER( 'Front_deskjkjammu' ));
|
|
|
|
select * from FO_OFFICE_USERS OU WHERE
|
|
TRIM( UPPER( OU.LOGIN_NAME )) = TRIM( UPPER( 'SS_user' ));
|
|
|
|
|
|
select * from FO_AUTH_USER_ROLE FURM WHERE USER_ID = 3999
|
|
select * from FO_AUTH_USER_ROLE FURM WHERE USER_ID = 3998
|
|
select * from FO_AUTH_USER_ROLE FURM WHERE USER_ID = 4018
|
|
|
|
select * from FO_AUTH_ROLE where (role_id) in (
|
|
124,185,1,3,8,70,73,78,85,103,104,105,113,119,123,125,
|
|
131,134,138,139,141,143,145,146,151,153,167,169,172,177,
|
|
178,188,3,71,79,85,104,105,114,123,131,134,138,140,141,
|
|
143,145,146,150,151,153,172,187)
|
|
order by role_id
|