/
Change Role
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
Attachments
, multiple selections available,
Related content
How to add a user and the associated roles
How to add a user and the associated roles
More like this
Draft of possible proposed updated process for Developer access to eMER on PROD (Transferred to Wiki)
Draft of possible proposed updated process for Developer access to eMER on PROD (Transferred to Wiki)
More like this
How to Create a NORMS User for Development Purposes
How to Create a NORMS User for Development Purposes
More like this
Creating an Organization and External User
Creating an Organization and External User
More like this
Error adding Security in TC Person
Error adding Security in TC Person
More like this
Refreshing the 2FA database
Refreshing the 2FA database
More like this