SCC_DA_DSEC_VW(SQL View) |
Index Back |
|---|---|
Delegator Security viewDelegator Security view |
| SELECT DISTINCT F.PNLNAME ,G.PNLGRPNAME ,D.MENUNAME , D.BARNAME , D.BARITEMNAME , E.PAGEACCESSDESCR , D.DISPLAYONLY ,C.ROLEUSER FROM PSOPRDEFN A , PSROLECLASS B , PSROLEUSER C , PSAUTHITEM D , PSPGEACCESSDESC E , PSPNLGROUP F , PSMENUITEM G WHERE ( B.ROLENAME = C.ROLENAME AND D.MENUNAME = G.MENUNAME AND D.BARNAME = G.BARNAME AND D.BARITEMNAME = G.ITEMNAME AND F.PNLGRPNAME = G.PNLGRPNAME AND A.OPRID = C.ROLEUSER AND B.CLASSID = D.CLASSID AND F.ITEMNAME = D.PNLITEMNAME AND D.MENUNAME NOT IN ('APPLICATION_DESIGNER','CLIENTPROCESS','DATA_MOVER','IMPORT_MANAGER','OBJECT_SECURITY','QUERY') AND D.MENUNAME NOT LIKE 'WEBLIB%' AND D.AUTHORIZEDACTIONS = E.AUTHORIZEDACTIONS ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_DA_DELGPG_NAME | Character(40) | VARCHAR2(40) NOT NULL |
Page Name
Prompt Table: SCC_DA_PG_D_VW |
| 2 | SCC_DA_DELEG_COMP | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSPNLGRPDEFN_VW |
| 3 | SCC_DA_DELEG_MENU | Character(30) | VARCHAR2(30) NOT NULL |
Pop Select tool menu name field. Used for transfering to the tool's edit page.
Prompt Table: SCC_DA_MENU_DVW |
| 4 | SCC_DA_DLG_BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Pop Select tool bar name field. Used for transfering to the tool's edit page.
Prompt Table: SCC_DA_BAR_D_VW |
| 5 | SCC_DA_DELEG_ITEM | Character(30) | VARCHAR2(30) NOT NULL |
Pop Select tool item name field. Used for transfering to the tool's edit page.
Prompt Table: SCC_DA_ITM_D_VW |
| 6 | SCC_DA_DELEG_ACTN | Character(100) | VARCHAR2(100) NOT NULL | Action Mode |
| 7 | DISPLAYONLY | Number(1,0) | SMALLINT NOT NULL |
Display Only
1/0 Table Edit (1=True, 0=False) |
| 8 | SCC_DA_DELEG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Delegator Oprid |