Change Role
- Tsizis, Mark (TC TC)
Owned by Tsizis, Mark (TC TC)
Making Internal User a Security Officer in DEV SEC - LEISD-LEISAUTH
select * from TR030_APPLICATION
APPLICATION_CD APPLICATION_ELBL
---------------- --------------------------------------------------
1 LEIS Authentication (LEISA)
2 Locomotive Emissions Information System (LEIS)
###############################################################################################
select * from TR021_ROLE
ROLE_CD APPLICATION_CD ROLE_ELBL
-------------------- -------------------------------- ----------------------------------------
6 2 Program Officer
5 2 Railway Company Responsible Person
4 2 Railway Company Contact
3 1 LEISA User
1 1 Security Officer
2 1 PIN Officer
7 1 Program Officer [LEISA]
7 rows selected
############################################################################################
select * from AC043_STAKEHOLDER_INTERNAL where USER_ID='POULINJ'
STAKEHOLDER_ID USER_ID DATE_CREATED_DTE
-------------- ------- ----------------
72 POULINJ 18-DEC-17
############################################################################################
select * from YR020_STAKEHOLDER_ROLE where STAKEHOLDER_ID=72
ROLE_CD APPLICATION_CD STAKEHOLDER_ID
-------------------- -------------------------------- --------------
6 2 72
7 1 72
-- 7/1 Program Officer [LEISA] to 1/1 Security Officer
UPDATE YR020_STAKEHOLDER_ROLE SET ROLE_CD = 1 WHERE STAKEHOLDER_ID=72 and APPLICATION_CD = 1;
1 rows updated.
select * from YR020_STAKEHOLDER_ROLE where STAKEHOLDER_ID=72 and APPLICATION_CD = 1
ROLE_CD APPLICATION_CD STAKEHOLDER_ID DATE_CREATED_DTE DATE_CURRENT_DTE DATE_LAST_UPDATE_DTE
------- ----------------------------- ---------------- ---------------- ---------------- ---
1 1 72 18-DEC-17 16-MAY-23 16-MAY-23
