Subversion Repositories DevTools

Rev

Rev 3943 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3943 Rev 5297
Line 1... Line 1...
1 
--------------------------------------------------------
 1 
--------------------------------------------------------
2 
--  File created - Thursday-August-01-2013
2 
--  File created - Tuesday-October-06-2015
3 
--------------------------------------------------------
 3 
--------------------------------------------------------
4 
--------------------------------------------------------
 4 
--------------------------------------------------------
- 
 
 5 
--  DDL for Type ACCMGR_NUMBER_TAB_T
- 
 
 6 
--------------------------------------------------------
- 
 
 7 
 
- 
 
 8 
  CREATE OR REPLACE TYPE "ACCESS_MANAGER"."ACCMGR_NUMBER_TAB_T" as TABLE of NUMBER
- 
 
 9 
 
- 
 
 10 
/
- 
 
 11 
--------------------------------------------------------
- 
 
 12 
--  DDL for Sequence SEQ_APP_ID
- 
 
 13 
--------------------------------------------------------
- 
 
 14 
 
- 
 
 15 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_APP_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 20 ORDER  NOCYCLE ;
- 
 
 16 
--------------------------------------------------------
- 
 
 17 
--  DDL for Sequence SEQ_DT_ID
- 
 
 18 
--------------------------------------------------------
- 
 
 19 
 
- 
 
 20 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_DT_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 261 CACHE 20 ORDER  NOCYCLE ;
- 
 
 21 
--------------------------------------------------------
- 
 
 22 
--  DDL for Sequence SEQ_OBJ_ID
- 
 
 23 
--------------------------------------------------------
- 
 
 24 
 
- 
 
 25 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_OBJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1401 CACHE 20 ORDER  NOCYCLE ;
- 
 
 26 
--------------------------------------------------------
- 
 
 27 
--  DDL for Sequence SEQ_ROLE_ID
- 
 
 28 
--------------------------------------------------------
- 
 
 29 
 
- 
 
 30 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_ROLE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1621 CACHE 20 ORDER  NOCYCLE ;
- 
 
 31 
--------------------------------------------------------
- 
 
 32 
--  DDL for Sequence SEQ_USER_ID
- 
 
 33 
--------------------------------------------------------
- 
 
 34 
 
- 
 
 35 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 12862 CACHE 20 ORDER  NOCYCLE ;
- 
 
 36 
--------------------------------------------------------
- 
 
 37 
--  DDL for Table APPLICATIONS
- 
 
 38 
--------------------------------------------------------
- 
 
 39 
 
- 
 
 40 
  CREATE TABLE "ACCESS_MANAGER"."APPLICATIONS"
- 
 
 41 
   (	"APP_ID" NUMBER,
- 
 
 42 
	"APPLICATION_NAME" VARCHAR2(1000 BYTE),
- 
 
 43 
	"DB_SCHEMA" VARCHAR2(1000 BYTE),
- 
 
 44 
	"TNS_NAME" VARCHAR2(1000 BYTE),
- 
 
 45 
	"SCHEMA_USERNAME" VARCHAR2(255 BYTE),
- 
 
 46 
	"SCHEMA_PASSWORD" VARCHAR2(255 BYTE),
- 
 
 47 
	"ACRONYM" VARCHAR2(3 BYTE),
- 
 
 48 
	"IS_RUNNING" CHAR(1 BYTE)
- 
 
 49 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 50 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 51 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 52 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 53 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 54 
--------------------------------------------------------
- 
 
 55 
--  DDL for Table APPLICATION_PAGES
- 
 
 56 
--------------------------------------------------------
- 
 
 57 
 
- 
 
 58 
  CREATE TABLE "ACCESS_MANAGER"."APPLICATION_PAGES"
- 
 
 59 
   (	"PAGE_ID" NUMBER,
- 
 
 60 
	"APP_ID" NUMBER,
- 
 
 61 
	"PAGE_NAME" VARCHAR2(1000 BYTE)
- 
 
 62 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 63 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 64 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 65 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 66 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 67 
--------------------------------------------------------
- 
 
 68 
--  DDL for Table CONTROL_OBJECTS
- 
 
 69 
--------------------------------------------------------
- 
 
 70 
 
- 
 
 71 
  CREATE TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS"
- 
 
 72 
   (	"OBJ_ID" NUMBER,
- 
 
 73 
	"APP_ID" NUMBER,
- 
 
 74 
	"OBJ_NAME" VARCHAR2(1000 BYTE),
- 
 
 75 
	"PARENT_OBJ_ID" NUMBER,
- 
 
 76 
	"OBJ_DESCRIPTION" VARCHAR2(1000 BYTE)
- 
 
 77 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 78 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 79 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 80 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 81 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 82 
--------------------------------------------------------
- 
 
 83 
--  DDL for Table DATA_PERMISSIONS
- 
 
 84 
--------------------------------------------------------
- 
 
 85 
 
- 
 
 86 
  CREATE TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS"
- 
 
 87 
   (	"DT_ID" NUMBER,
- 
 
 88 
	"ROLE_ID" NUMBER,
- 
 
 89 
	"REF_COLUMN_VAL" NUMBER,
- 
 
 90 
	"PERM_ID" NUMBER,
- 
 
 91 
	"PERM_VALUE" CHAR(1 BYTE)
- 
 
 92 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 93 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 94 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 95 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 96 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 97 
--------------------------------------------------------
- 
 
 98 
--  DDL for Table DATA_TABLES
- 
 
 99 
--------------------------------------------------------
- 
 
 100 
 
- 
 
 101 
  CREATE TABLE "ACCESS_MANAGER"."DATA_TABLES"
- 
 
 102 
   (	"DT_ID" NUMBER,
- 
 
 103 
	"OBJ_ID" NUMBER,
- 
 
 104 
	"TABLE_NAME" VARCHAR2(1000 BYTE),
- 
 
 105 
	"REF_COLUMN_NAME" VARCHAR2(1000 BYTE),
- 
 
 106 
	"DISPLAY_COLUMN_NAME" VARCHAR2(1000 BYTE)
- 
 
 107 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 108 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 109 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 110 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 111 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 112 
--------------------------------------------------------
- 
 
 113 
--  DDL for Table DEF_ACTION_BUTTONS
- 
 
 114 
--------------------------------------------------------
- 
 
 115 
 
- 
 
 116 
  CREATE TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS"
- 
 
 117 
   (	"ABTN_ID" NUMBER,
- 
 
 118 
	"ABTN_NAME" VARCHAR2(1000 BYTE),
- 
 
 119 
	"TEXT" VARCHAR2(50 BYTE),
- 
 
 120 
	"ACTION_LINK" VARCHAR2(4000 BYTE),
- 
 
 121 
	"EVENT_HANDLER" VARCHAR2(4000 BYTE),
- 
 
 122 
	"IMG_ENABLED" VARCHAR2(1000 BYTE),
- 
 
 123 
	"IMG_DISABLED" VARCHAR2(1000 BYTE),
- 
 
 124 
	"HINT" VARCHAR2(50 BYTE),
- 
 
 125 
	"VISIBLE" CHAR(1 BYTE),
- 
 
 126 
	"ACTIVE" CHAR(1 BYTE),
- 
 
 127 
	"IS_READONLY_ACTION" CHAR(1 BYTE)
- 
 
 128 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 129 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 130 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 131 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 132 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 133 
--------------------------------------------------------
- 
 
 134 
--  DDL for Table LOGIN_TRAIL
- 
 
 135 
--------------------------------------------------------
- 
 
 136 
 
- 
 
 137 
  CREATE TABLE "ACCESS_MANAGER"."LOGIN_TRAIL"
- 
 
 138 
   (	"ENUM_EVENT" NUMBER,
- 
 
 139 
	"USER_NAME" VARCHAR2(1000 BYTE),
- 
 
 140 
	"CLIENT_IP" VARCHAR2(255 BYTE),
- 
 
 141 
	"APP_ID" NUMBER,
- 
 
 142 
	"STAMP" DATE,
- 
 
 143 
	"COMMENTS" VARCHAR2(4000 BYTE)
- 
 
 144 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 145 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 146 
  STORAGE(INITIAL 7340032 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 147 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 148 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 149 
--------------------------------------------------------
- 
 
 150 
--  DDL for Table PAGE_CONTROL_OBJECTS
- 
 
 151 
--------------------------------------------------------
- 
 
 152 
 
- 
 
 153 
  CREATE TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS"
- 
 
 154 
   (	"PAGE_ID" NUMBER,
- 
 
 155 
	"OBJ_ID" NUMBER
- 
 
 156 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 157 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 158 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 159 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 160 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 161 
--------------------------------------------------------
- 
 
 162 
--  DDL for Table PERMISSION_TYPES
- 
 
 163 
--------------------------------------------------------
- 
 
 164 
 
- 
 
 165 
  CREATE TABLE "ACCESS_MANAGER"."PERMISSION_TYPES"
- 
 
 166 
   (	"PERM_ID" NUMBER,
- 
 
 167 
	"PERM_NAME" VARCHAR2(255 BYTE)
- 
 
 168 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 169 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 170 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 171 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 172 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 173 
--------------------------------------------------------
- 
 
 174 
--  DDL for Table ROLES
- 
 
 175 
--------------------------------------------------------
- 
 
 176 
 
- 
 
 177 
  CREATE TABLE "ACCESS_MANAGER"."ROLES"
- 
 
 178 
   (	"ROLE_ID" NUMBER,
- 
 
 179 
	"APP_ID" NUMBER,
- 
 
 180 
	"ROLE_NAME" VARCHAR2(1000 BYTE),
- 
 
 181 
	"IS_ROLE_VARIATION" CHAR(1 BYTE),
- 
 
 182 
	"COMMENTS" VARCHAR2(4000 BYTE)
- 
 
 183 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 184 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 185 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 186 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 187 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 188 
--------------------------------------------------------
- 
 
 189 
--  DDL for Table ROLE_PRIVILEGES
- 
 
 190 
--------------------------------------------------------
- 
 
 191 
 
- 
 
 192 
  CREATE TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES"
- 
 
 193 
   (	"ROLE_ID" NUMBER,
- 
 
 194 
	"OBJ_ID" NUMBER,
- 
 
 195 
	"PERM_ID" NUMBER,
- 
 
 196 
	"PERM_VALUE" CHAR(1 BYTE)
- 
 
 197 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 198 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 199 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 200 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 201 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 202 
--------------------------------------------------------
- 
 
 203 
--  DDL for Table USERS
- 
 
 204 
--------------------------------------------------------
- 
 
 205 
 
- 
 
 206 
  CREATE TABLE "ACCESS_MANAGER"."USERS"
- 
 
 207 
   (	"USER_ID" NUMBER,
- 
 
 208 
	"FULL_NAME" VARCHAR2(255 BYTE),
- 
 
 209 
	"USER_NAME" VARCHAR2(1000 BYTE),
- 
 
 210 
	"USER_PASSWORD" VARCHAR2(4000 BYTE),
- 
 
 211 
	"USER_EMAIL" VARCHAR2(1000 BYTE),
- 
 
 212 
	"DOMAIN" VARCHAR2(1000 BYTE),
- 
 
 213 
	"IS_DISABLED" CHAR(1 BYTE),
- 
 
 214 
	"IS_ONLINE" CHAR(1 BYTE),
- 
 
 215 
	"ONLINE_AT" VARCHAR2(50 BYTE),
- 
 
 216 
	"LAST_VISIT" DATE,
- 
 
 217 
	"LAST_REQUEST" NUMBER
- 
 
 218 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 219 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 220 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 221 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 222 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 223 
--------------------------------------------------------
- 
 
 224 
--  DDL for Table USER_APPLICATIONS
- 
 
 225 
--------------------------------------------------------
- 
 
 226 
 
- 
 
 227 
  CREATE TABLE "ACCESS_MANAGER"."USER_APPLICATIONS"
- 
 
 228 
   (	"USER_ID" NUMBER,
- 
 
 229 
	"APP_ID" NUMBER,
- 
 
 230 
	"LAST_VISIT_STAMP" DATE
- 
 
 231 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 232 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 233 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 234 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 235 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 236 
--------------------------------------------------------
- 
 
 237 
--  DDL for Table USER_ROLES
- 
 
 238 
--------------------------------------------------------
- 
 
 239 
 
- 
 
 240 
  CREATE TABLE "ACCESS_MANAGER"."USER_ROLES"
- 
 
 241 
   (	"USER_ID" NUMBER,
- 
 
 242 
	"ROLE_ID" NUMBER
- 
 
 243 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 244 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 245 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 246 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 247 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 248 
--------------------------------------------------------
- 
 
 249 
--  DDL for Table VALIDATION_RULES
- 
 
 250 
--------------------------------------------------------
- 
 
 251 
 
- 
 
 252 
  CREATE TABLE "ACCESS_MANAGER"."VALIDATION_RULES"
- 
 
 253 
   (	"FIELD_NAME" VARCHAR2(1000 BYTE),
- 
 
 254 
	"IS_REQUIRED" CHAR(1 BYTE),
- 
 
 255 
	"IS_NUMERIC" CHAR(1 BYTE),
- 
 
 256 
	"MIN_NUMERIC_VALUE" NUMBER,
- 
 
 257 
	"MAX_NUMERIC_VALUE" NUMBER,
- 
 
 258 
	"IS_DATE" CHAR(1 BYTE),
- 
 
 259 
	"START_DATE" DATE,
- 
 
 260 
	"END_DATE" DATE,
- 
 
 261 
	"MIN_STRING_LENGTH" NUMBER,
- 
 
 262 
	"MAX_STRING_LENGTH" NUMBER,
- 
 
 263 
	"REGEXP" VARCHAR2(4000 BYTE),
- 
 
 264 
	"REGEXP_DESCRIPTION" VARCHAR2(50 BYTE)
- 
 
 265 
   ) SEGMENT CREATION IMMEDIATE
- 
 
 266 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- 
 
 267 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 268 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 269 
  TABLESPACE "RELEASEM_DATA" ;
- 
 
 270 
--------------------------------------------------------
- 
 
 271 
--  DDL for View CONTROLOBJECTS_VS_ROLES
- 
 
 272 
--------------------------------------------------------
- 
 
 273 
 
- 
 
 274 
  CREATE OR REPLACE FORCE VIEW "ACCESS_MANAGER"."CONTROLOBJECTS_VS_ROLES" ("APPLICATION ID", "APPLICATION NAME", "OBJECT_ID", "OBJECT NAME", "OBJECT DESCRIPTION", "ROLE ID", "ROLE NAME") AS
- 
 
 275 
  select distinct app.app_id, app.application_name, co.obj_id, co.obj_name, co.obj_description, ro.role_id, ro.role_name
- 
 
 276 
from applications app, control_objects co, roles ro, role_privileges rp
- 
 
 277 
where app.app_id=co.app_id
- 
 
 278 
and app.app_id=ro.app_id
- 
 
 279 
and ro.role_id=rp.role_id
- 
 
 280 
and rp.obj_id=co.obj_id
- 
 
 281 
order by co.obj_name;
- 
 
 282 
--------------------------------------------------------
- 
 
 283 
--  DDL for Index UNQ_PERMISSION_TYPES
- 
 
 284 
--------------------------------------------------------
- 
 
 285 
 
- 
 
 286 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_PERMISSION_TYPES" ON "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_NAME")
- 
 
 287 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 288 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 289 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 290 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 291 
--------------------------------------------------------
- 
 
 292 
--  DDL for Index PK_APPLICATION_PAGES
- 
 
 293 
--------------------------------------------------------
- 
 
 294 
 
- 
 
 295 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_APPLICATION_PAGES" ON "ACCESS_MANAGER"."APPLICATION_PAGES" ("PAGE_ID")
- 
 
 296 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 297 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 298 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 299 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 300 
--------------------------------------------------------
- 
 
 301 
--  DDL for Index PK_ROLES
- 
 
 302 
--------------------------------------------------------
- 
 
 303 
 
- 
 
 304 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_ROLES" ON "ACCESS_MANAGER"."ROLES" ("ROLE_ID")
- 
 
 305 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 306 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 307 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 308 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 309 
--------------------------------------------------------
- 
 
 310 
--  DDL for Index INX_ENUM_EVENT
- 
 
 311 
--------------------------------------------------------
- 
 
 312 
 
- 
 
 313 
  CREATE INDEX "ACCESS_MANAGER"."INX_ENUM_EVENT" ON "ACCESS_MANAGER"."LOGIN_TRAIL" ("ENUM_EVENT")
- 
 
 314 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 315 
  STORAGE(INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 316 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 317 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 318 
--------------------------------------------------------
- 
 
 319 
--  DDL for Index UNQ_ROLES
- 
 
 320 
--------------------------------------------------------
- 
 
 321 
 
- 
 
 322 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_ROLES" ON "ACCESS_MANAGER"."ROLES" ("APP_ID", "ROLE_NAME")
- 
 
 323 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 324 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 325 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 326 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 327 
--------------------------------------------------------
- 
 
 328 
--  DDL for Index UNQ_VALIDATION_RULES
- 
 
 329 
--------------------------------------------------------
- 
 
 330 
 
- 
 
 331 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_VALIDATION_RULES" ON "ACCESS_MANAGER"."VALIDATION_RULES" ("FIELD_NAME")
- 
 
 332 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 333 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 334 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 335 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 336 
--------------------------------------------------------
- 
 
 337 
--  DDL for Index UNQ_USERS
- 
 
 338 
--------------------------------------------------------
- 
 
 339 
 
- 
 
 340 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_USERS" ON "ACCESS_MANAGER"."USERS" ("USER_NAME")
- 
 
 341 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 342 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 343 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 344 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 345 
--------------------------------------------------------
- 
 
 346 
--  DDL for Index PK_USERS
- 
 
 347 
--------------------------------------------------------
- 
 
 348 
 
- 
 
 349 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_USERS" ON "ACCESS_MANAGER"."USERS" ("USER_ID")
- 
 
 350 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 351 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 352 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 353 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 354 
--------------------------------------------------------
- 
 
 355 
--  DDL for Index PK_APPLICATIONS
- 
 
 356 
--------------------------------------------------------
- 
 
 357 
 
- 
 
 358 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_APPLICATIONS" ON "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID")
- 
 
 359 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 360 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 361 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 362 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 363 
--------------------------------------------------------
- 
 
 364 
--  DDL for Index UNQ_ABTN_DEF
- 
 
 365 
--------------------------------------------------------
- 
 
 366 
 
- 
 
 367 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_ABTN_DEF" ON "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" ("ABTN_NAME")
- 
 
 368 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 369 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 370 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 371 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 372 
--------------------------------------------------------
- 
 
 373 
--  DDL for Index PK_DEF_ACTION_BUTTONS
- 
 
 374 
--------------------------------------------------------
- 
 
 375 
 
- 
 
 376 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_DEF_ACTION_BUTTONS" ON "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" ("ABTN_ID")
- 
 
 377 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 378 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 379 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 380 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 381 
--------------------------------------------------------
- 
 
 382 
--  DDL for Index UNQ_DATA_PERM
- 
 
 383 
--------------------------------------------------------
- 
 
 384 
 
- 
 
 385 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_DATA_PERM" ON "ACCESS_MANAGER"."DATA_PERMISSIONS" ("DT_ID", "ROLE_ID", "REF_COLUMN_VAL", "PERM_ID")
- 
 
 386 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 387 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 388 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 389 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 390 
--------------------------------------------------------
- 
 
 391 
--  DDL for Index UNQ_CONTROL_OBJ
- 
 
 392 
--------------------------------------------------------
- 
 
 393 
 
- 
 
 394 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_CONTROL_OBJ" ON "ACCESS_MANAGER"."CONTROL_OBJECTS" ("APP_ID", "OBJ_NAME")
- 
 
 395 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 396 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 397 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 398 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 399 
--------------------------------------------------------
- 
 
 400 
--  DDL for Index UNQ_APPLICATIONS
- 
 
 401 
--------------------------------------------------------
- 
 
 402 
 
- 
 
 403 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_APPLICATIONS" ON "ACCESS_MANAGER"."APPLICATIONS" ("APPLICATION_NAME")
- 
 
 404 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 405 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 406 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 407 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 408 
--------------------------------------------------------
- 
 
 409 
--  DDL for Index UNQ_PAGE_COBJ
- 
 
 410 
--------------------------------------------------------
- 
 
 411 
 
- 
 
 412 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_PAGE_COBJ" ON "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" ("PAGE_ID", "OBJ_ID")
- 
 
 413 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 414 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 415 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 416 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 417 
--------------------------------------------------------
- 
 
 418 
--  DDL for Index PK_PERMISSION_TYPES
- 
 
 419 
--------------------------------------------------------
- 
 
 420 
 
- 
 
 421 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_PERMISSION_TYPES" ON "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_ID")
- 
 
 422 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 423 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 424 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 425 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 426 
--------------------------------------------------------
- 
 
 427 
--  DDL for Index INX_CLIENT_IP
- 
 
 428 
--------------------------------------------------------
- 
 
 429 
 
- 
 
 430 
  CREATE INDEX "ACCESS_MANAGER"."INX_CLIENT_IP" ON "ACCESS_MANAGER"."LOGIN_TRAIL" ("CLIENT_IP")
- 
 
 431 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 432 
  STORAGE(INITIAL 6291456 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 433 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 434 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 435 
--------------------------------------------------------
- 
 
 436 
--  DDL for Index PK_CONTROL_OBJECTS
- 
 
 437 
--------------------------------------------------------
- 
 
 438 
 
- 
 
 439 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_CONTROL_OBJECTS" ON "ACCESS_MANAGER"."CONTROL_OBJECTS" ("OBJ_ID")
- 
 
 440 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 441 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 442 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 443 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 444 
--------------------------------------------------------
- 
 
 445 
--  DDL for Index INX_USER_NAME
- 
 
 446 
--------------------------------------------------------
- 
 
 447 
 
- 
 
 448 
  CREATE INDEX "ACCESS_MANAGER"."INX_USER_NAME" ON "ACCESS_MANAGER"."LOGIN_TRAIL" ("USER_NAME")
- 
 
 449 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 450 
  STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 451 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 452 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 453 
--------------------------------------------------------
- 
 
 454 
--  DDL for Index UNQ_USER_ROLES
- 
 
 455 
--------------------------------------------------------
- 
 
 456 
 
- 
 
 457 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_USER_ROLES" ON "ACCESS_MANAGER"."USER_ROLES" ("USER_ID", "ROLE_ID")
- 
 
 458 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 459 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 460 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 461 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 462 
--------------------------------------------------------
- 
 
 463 
--  DDL for Index UNQ_APP_PAGES
- 
 
 464 
--------------------------------------------------------
- 
 
 465 
 
- 
 
 466 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_APP_PAGES" ON "ACCESS_MANAGER"."APPLICATION_PAGES" ("APP_ID", "PAGE_NAME")
- 
 
 467 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 468 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 469 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 470 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 471 
--------------------------------------------------------
- 
 
 472 
--  DDL for Index UNQ_DATA_TABLE
- 
 
 473 
--------------------------------------------------------
- 
 
 474 
 
- 
 
 475 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_DATA_TABLE" ON "ACCESS_MANAGER"."DATA_TABLES" ("TABLE_NAME", "OBJ_ID", "REF_COLUMN_NAME")
- 
 
 476 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 477 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 478 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 479 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 480 
--------------------------------------------------------
- 
 
 481 
--  DDL for Index PK_DATA_TABLES
- 
 
 482 
--------------------------------------------------------
- 
 
 483 
 
- 
 
 484 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_DATA_TABLES" ON "ACCESS_MANAGER"."DATA_TABLES" ("DT_ID")
- 
 
 485 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 486 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 487 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 488 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 489 
--------------------------------------------------------
- 
 
 490 
--  DDL for Index UNQ_USER_APPS
- 
 
 491 
--------------------------------------------------------
- 
 
 492 
 
- 
 
 493 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_USER_APPS" ON "ACCESS_MANAGER"."USER_APPLICATIONS" ("USER_ID", "APP_ID")
- 
 
 494 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 495 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 496 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 497 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 498 
--------------------------------------------------------
- 
 
 499 
--  DDL for Index UNQ_ROLE_OBJ_PERM
- 
 
 500 
--------------------------------------------------------
- 
 
 501 
 
- 
 
 502 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_ROLE_OBJ_PERM" ON "ACCESS_MANAGER"."ROLE_PRIVILEGES" ("ROLE_ID", "OBJ_ID", "PERM_ID")
- 
 
 503 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 504 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 505 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 506 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 507 
--------------------------------------------------------
- 
 
 508 
--  Constraints for Table DATA_TABLES
- 
 
 509 
--------------------------------------------------------
- 
 
 510 
 
- 
 
 511 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" ADD CONSTRAINT "PK_DATA_TABLES" PRIMARY KEY ("DT_ID")
- 
 
 512 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 513 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 514 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 515 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 516 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" MODIFY ("DISPLAY_COLUMN_NAME" NOT NULL ENABLE);
- 
 
 517 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" MODIFY ("REF_COLUMN_NAME" NOT NULL ENABLE);
- 
 
 518 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" MODIFY ("TABLE_NAME" NOT NULL ENABLE);
- 
 
 519 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" MODIFY ("OBJ_ID" NOT NULL ENABLE);
- 
 
 520 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" MODIFY ("DT_ID" NOT NULL ENABLE);
- 
 
 521 
--------------------------------------------------------
- 
 
 522 
--  Constraints for Table APPLICATIONS
- 
 
 523 
--------------------------------------------------------
- 
 
 524 
 
- 
 
 525 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" ADD CONSTRAINT "PK_APPLICATIONS" PRIMARY KEY ("APP_ID")
- 
 
 526 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 527 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 528 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 529 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 530 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("IS_RUNNING" NOT NULL ENABLE);
- 
 
 531 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("ACRONYM" NOT NULL ENABLE);
- 
 
 532 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("APPLICATION_NAME" NOT NULL ENABLE);
- 
 
 533 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("APP_ID" NOT NULL ENABLE);
- 
 
 534 
--------------------------------------------------------
- 
 
 535 
--  Constraints for Table PERMISSION_TYPES
- 
 
 536 
--------------------------------------------------------
- 
 
 537 
 
- 
 
 538 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" ADD CONSTRAINT "PK_PERMISSION_TYPES" PRIMARY KEY ("PERM_ID")
- 
 
 539 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 540 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 541 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 542 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 543 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" MODIFY ("PERM_NAME" NOT NULL ENABLE);
- 
 
 544 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" MODIFY ("PERM_ID" NOT NULL ENABLE);
- 
 
 545 
--------------------------------------------------------
- 
 
 546 
--  Constraints for Table USER_APPLICATIONS
- 
 
 547 
--------------------------------------------------------
- 
 
 548 
 
- 
 
 549 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" MODIFY ("APP_ID" NOT NULL ENABLE);
- 
 
 550 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 551 
--------------------------------------------------------
- 
 
 552 
--  Constraints for Table USER_ROLES
- 
 
 553 
--------------------------------------------------------
- 
 
 554 
 
- 
 
 555 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
- 
 
 556 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 557 
--------------------------------------------------------
- 
 
 558 
--  Constraints for Table APPLICATION_PAGES
- 
 
 559 
--------------------------------------------------------
- 
 
 560 
 
- 
 
 561 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD CONSTRAINT "PK_APPLICATION_PAGES" PRIMARY KEY ("PAGE_ID")
- 
 
 562 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 563 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 564 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 565 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 566 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" MODIFY ("PAGE_NAME" NOT NULL ENABLE);
- 
 
 567 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" MODIFY ("APP_ID" NOT NULL ENABLE);
- 
 
 568 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" MODIFY ("PAGE_ID" NOT NULL ENABLE);
- 
 
 569 
--------------------------------------------------------
- 
 
 570 
--  Constraints for Table USERS
- 
 
 571 
--------------------------------------------------------
- 
 
 572 
 
- 
 
 573 
  ALTER TABLE "ACCESS_MANAGER"."USERS" ADD CONSTRAINT "PK_USERS" PRIMARY KEY ("USER_ID")
- 
 
 574 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 575 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 576 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 577 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 578 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("USER_NAME" NOT NULL ENABLE);
- 
 
 579 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("FULL_NAME" NOT NULL ENABLE);
- 
 
 580 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 581 
--------------------------------------------------------
- 
 
 582 
--  Constraints for Table CONTROL_OBJECTS
- 
 
 583 
--------------------------------------------------------
- 
 
 584 
 
- 
 
 585 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" ADD CONSTRAINT "PK_CONTROL_OBJECTS" PRIMARY KEY ("OBJ_ID")
- 
 
 586 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 587 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 588 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 589 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 590 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" MODIFY ("OBJ_NAME" NOT NULL ENABLE);
- 
 
 591 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" MODIFY ("APP_ID" NOT NULL ENABLE);
- 
 
 592 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" MODIFY ("OBJ_ID" NOT NULL ENABLE);
- 
 
 593 
--------------------------------------------------------
- 
 
 594 
--  Constraints for Table LOGIN_TRAIL
- 
 
 595 
--------------------------------------------------------
- 
 
 596 
 
- 
 
 597 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("STAMP" NOT NULL ENABLE);
- 
 
 598 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("USER_NAME" NOT NULL ENABLE);
- 
 
 599 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("ENUM_EVENT" NOT NULL ENABLE);
- 
 
 600 
--------------------------------------------------------
- 
 
 601 
--  Constraints for Table ROLE_PRIVILEGES
- 
 
 602 
--------------------------------------------------------
- 
 
 603 
 
- 
 
 604 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("PERM_VALUE" NOT NULL ENABLE);
- 
 
 605 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("PERM_ID" NOT NULL ENABLE);
- 
 
 606 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("OBJ_ID" NOT NULL ENABLE);
- 
 
 607 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
- 
 
 608 
--------------------------------------------------------
- 
 
 609 
--  Constraints for Table PAGE_CONTROL_OBJECTS
- 
 
 610 
--------------------------------------------------------
- 
 
 611 
 
- 
 
 612 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" MODIFY ("OBJ_ID" NOT NULL ENABLE);
- 
 
 613 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" MODIFY ("PAGE_ID" NOT NULL ENABLE);
- 
 
 614 
--------------------------------------------------------
- 
 
 615 
--  Constraints for Table DATA_PERMISSIONS
- 
 
 616 
--------------------------------------------------------
- 
 
 617 
 
- 
 
 618 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("PERM_VALUE" NOT NULL ENABLE);
- 
 
 619 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("PERM_ID" NOT NULL ENABLE);
- 
 
 620 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("REF_COLUMN_VAL" NOT NULL ENABLE);
- 
 
 621 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("ROLE_ID" NOT NULL ENABLE);
- 
 
 622 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("DT_ID" NOT NULL ENABLE);
- 
 
 623 
--------------------------------------------------------
- 
 
 624 
--  Constraints for Table VALIDATION_RULES
- 
 
 625 
--------------------------------------------------------
- 
 
 626 
 
- 
 
 627 
  ALTER TABLE "ACCESS_MANAGER"."VALIDATION_RULES" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
- 
 
 628 
  ALTER TABLE "ACCESS_MANAGER"."VALIDATION_RULES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
- 
 
 629 
--------------------------------------------------------
- 
 
 630 
--  Constraints for Table ROLES
- 
 
 631 
--------------------------------------------------------
- 
 
 632 
 
- 
 
 633 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" ADD CONSTRAINT "PK_ROLES" PRIMARY KEY ("ROLE_ID")
- 
 
 634 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 635 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 636 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 637 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 638 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("ROLE_NAME" NOT NULL ENABLE);
- 
 
 639 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("APP_ID" NOT NULL ENABLE);
- 
 
 640 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
- 
 
 641 
--------------------------------------------------------
- 
 
 642 
--  Constraints for Table DEF_ACTION_BUTTONS
- 
 
 643 
--------------------------------------------------------
- 
 
 644 
 
- 
 
 645 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" ADD CONSTRAINT "PK_DEF_ACTION_BUTTONS" PRIMARY KEY ("ABTN_ID")
- 
 
 646 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 647 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 648 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 649 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
- 
 
 650 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("IS_READONLY_ACTION" NOT NULL ENABLE);
- 
 
 651 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("ACTIVE" NOT NULL ENABLE);
- 
 
 652 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("VISIBLE" NOT NULL ENABLE);
- 
 
 653 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("ABTN_NAME" NOT NULL ENABLE);
- 
 
 654 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("ABTN_ID" NOT NULL ENABLE);
- 
 
 655 
--------------------------------------------------------
- 
 
 656 
--  Ref Constraints for Table APPLICATION_PAGES
- 
 
 657 
--------------------------------------------------------
- 
 
 658 
 
- 
 
 659 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD CONSTRAINT "FK_APP_PAGE_REF_APP" FOREIGN KEY ("APP_ID")
- 
 
 660 
	  REFERENCES "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID") ENABLE;
- 
 
 661 
--------------------------------------------------------
- 
 
 662 
--  Ref Constraints for Table CONTROL_OBJECTS
- 
 
 663 
--------------------------------------------------------
- 
 
 664 
 
- 
 
 665 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" ADD CONSTRAINT "FK_CONTROL_OBJ_REF_APPLICS" FOREIGN KEY ("APP_ID")
- 
 
 666 
	  REFERENCES "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID") ENABLE;
- 
 
 667 
--------------------------------------------------------
- 
 
 668 
--  Ref Constraints for Table DATA_PERMISSIONS
- 
 
 669 
--------------------------------------------------------
- 
 
 670 
 
- 
 
 671 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" ADD CONSTRAINT "FK_DATA_PERM_REF_DATA_TABLE" FOREIGN KEY ("DT_ID")
- 
 
 672 
	  REFERENCES "ACCESS_MANAGER"."DATA_TABLES" ("DT_ID") ENABLE;
- 
 
 673 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" ADD CONSTRAINT "FK_DATA_PERM_REF_PERM_TYPES" FOREIGN KEY ("PERM_ID")
- 
 
 674 
	  REFERENCES "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_ID") ENABLE;
- 
 
 675 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" ADD CONSTRAINT "FK_DATA_PER_REF_ROLES" FOREIGN KEY ("ROLE_ID")
- 
 
 676 
	  REFERENCES "ACCESS_MANAGER"."ROLES" ("ROLE_ID") ENABLE;
- 
 
 677 
--------------------------------------------------------
- 
 
 678 
--  Ref Constraints for Table DATA_TABLES
- 
 
 679 
--------------------------------------------------------
- 
 
 680 
 
- 
 
 681 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" ADD CONSTRAINT "FK_DATA_TABLE_REF_OBJ" FOREIGN KEY ("OBJ_ID")
- 
 
 682 
	  REFERENCES "ACCESS_MANAGER"."CONTROL_OBJECTS" ("OBJ_ID") ENABLE;
- 
 
 683 
--------------------------------------------------------
- 
 
 684 
--  Ref Constraints for Table PAGE_CONTROL_OBJECTS
- 
 
 685 
--------------------------------------------------------
- 
 
 686 
 
- 
 
 687 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" ADD CONSTRAINT "FK_PAGE_CON_REF_APP_PAGES" FOREIGN KEY ("PAGE_ID")
- 
 
 688 
	  REFERENCES "ACCESS_MANAGER"."APPLICATION_PAGES" ("PAGE_ID") ENABLE;
- 
 
 689 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" ADD CONSTRAINT "FK_PAGE_CON_REF_CONTROL_OBJS" FOREIGN KEY ("OBJ_ID")
- 
 
 690 
	  REFERENCES "ACCESS_MANAGER"."CONTROL_OBJECTS" ("OBJ_ID") ENABLE;
- 
 
 691 
--------------------------------------------------------
- 
 
 692 
--  Ref Constraints for Table ROLES
- 
 
 693 
--------------------------------------------------------
- 
 
 694 
 
- 
 
 695 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" ADD CONSTRAINT "FK_ROLES_REF_APPLICS" FOREIGN KEY ("APP_ID")
- 
 
 696 
	  REFERENCES "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID") ENABLE;
- 
 
 697 
--------------------------------------------------------
- 
 
 698 
--  Ref Constraints for Table ROLE_PRIVILEGES
- 
 
 699 
--------------------------------------------------------
- 
 
 700 
 
- 
 
 701 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" ADD CONSTRAINT "FK_ROLE_OBJ_REF_OBJS" FOREIGN KEY ("OBJ_ID")
- 
 
 702 
	  REFERENCES "ACCESS_MANAGER"."CONTROL_OBJECTS" ("OBJ_ID") ENABLE;
- 
 
 703 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" ADD CONSTRAINT "FK_ROLE_OBJ_REF_PERMISS" FOREIGN KEY ("PERM_ID")
- 
 
 704 
	  REFERENCES "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_ID") ENABLE;
- 
 
 705 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" ADD CONSTRAINT "FK_ROLE_OBJ_REF_ROLES" FOREIGN KEY ("ROLE_ID")
- 
 
 706 
	  REFERENCES "ACCESS_MANAGER"."ROLES" ("ROLE_ID") ON DELETE CASCADE ENABLE;
- 
 
 707 
--------------------------------------------------------
- 
 
 708 
--  Ref Constraints for Table USER_APPLICATIONS
- 
 
 709 
--------------------------------------------------------
- 
 
 710 
 
- 
 
 711 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" ADD CONSTRAINT "FK_USER_APPS_REF_APPS" FOREIGN KEY ("APP_ID")
- 
 
 712 
	  REFERENCES "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID") ENABLE;
- 
 
 713 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" ADD CONSTRAINT "FK_USER_APP_REF_USERS" FOREIGN KEY ("USER_ID")
- 
 
 714 
	  REFERENCES "ACCESS_MANAGER"."USERS" ("USER_ID") ENABLE;
- 
 
 715 
--------------------------------------------------------
- 
 
 716 
--  Ref Constraints for Table USER_ROLES
- 
 
 717 
--------------------------------------------------------
- 
 
 718 
 
- 
 
 719 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" ADD CONSTRAINT "FK_USER_ROLES_REF_ROLES" FOREIGN KEY ("ROLE_ID")
- 
 
 720 
	  REFERENCES "ACCESS_MANAGER"."ROLES" ("ROLE_ID") ON DELETE CASCADE ENABLE;
- 
 
 721 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" ADD CONSTRAINT "FK_USER_ROLES_REF_USERS" FOREIGN KEY ("USER_ID")
- 
 
 722 
	  REFERENCES "ACCESS_MANAGER"."USERS" ("USER_ID") ON DELETE CASCADE ENABLE;
- 
 
 723 
--------------------------------------------------------
5 
--  DDL for Function IN_LIST_NUMBER
 724 
--  DDL for Function IN_LIST_NUMBER
6 
--------------------------------------------------------
 725 
--------------------------------------------------------
7 
 
 726 
 
8 
  CREATE OR REPLACE FUNCTION "IN_LIST_NUMBER" ( sInList IN VARCHAR2 ) RETURN ACCMGR_NUMBER_TAB_t IS
 727 
  CREATE OR REPLACE FUNCTION "ACCESS_MANAGER"."IN_LIST_NUMBER" ( sInList IN VARCHAR2 ) RETURN ACCMGR_NUMBER_TAB_t IS
9 
 
 728 
 
10 
/* ---------------------------------------------------------------------------
 729 
/* ---------------------------------------------------------------------------
11 
    Version: 1.0.0
 730 
    Version: 1.0.0
12 
   --------------------------------------------------------------------------- */
 731 
   --------------------------------------------------------------------------- */
13 
 
 732 
 
Line 30... Line 749...
30 
 
 749 
 
31 
	RETURN sync_rtags;
 750 
	RETURN sync_rtags;
32 
END IN_LIST_NUMBER;
 751 
END IN_LIST_NUMBER;
33 
 
 752 
 
34 
/
 753 
/
35 
 
 - 
 
36 
/
 - 
 
37 
--------------------------------------------------------
 754 
--------------------------------------------------------
38 
--  DDL for Function IS_SAME_STRING
 755 
--  DDL for Function IS_SAME_STRING
39 
--------------------------------------------------------
 756 
--------------------------------------------------------
40 
 
 757 
 
41 
  CREATE OR REPLACE FUNCTION "IS_SAME_STRING" ( sStringOne IN VARCHAR2,
 758 
  CREATE OR REPLACE FUNCTION "ACCESS_MANAGER"."IS_SAME_STRING" ( sStringOne IN VARCHAR2,
42 
	   	  		  		   				  	sStringTwo IN VARCHAR2 ) RETURN BOOLEAN IS
 759 
	   	  		  		   				  	sStringTwo IN VARCHAR2 ) RETURN BOOLEAN IS
43 
 
 760 
 
44 
/* ---------------------------------------------------------------------------
 761 
/* ---------------------------------------------------------------------------
45 
    Version: 1.0.0
 762 
    Version: 1.0.0
46 
   --------------------------------------------------------------------------- */
 763 
   --------------------------------------------------------------------------- */
Line 58... Line 775...
58 
 
 775 
 
59 
	RETURN ReturnValue;
 776 
	RETURN ReturnValue;
60 
END IS_SAME_STRING;
 777 
END IS_SAME_STRING;
61 
 
 778 
 
62 
/
 779 
/
63 
 
 - 
 
64 
/
 - 
 
65 
--------------------------------------------------------
 780 
--------------------------------------------------------
66 
--  DDL for Package PK_AMUTILS
 781 
--  DDL for Package PK_AMUTILS
67 
--------------------------------------------------------
 782 
--------------------------------------------------------
68 
 
 783 
 
69 
  CREATE OR REPLACE PACKAGE "PK_AMUTILS" IS
 784 
  CREATE OR REPLACE PACKAGE "ACCESS_MANAGER"."PK_AMUTILS" IS
70 
 
 785 
 
71 
	PROCEDURE Log_Access ( nEvent IN LOGIN_TRAIL.ENUM_EVENT%TYPE,
 786 
	PROCEDURE Log_Access ( nEvent IN LOGIN_TRAIL.ENUM_EVENT%TYPE,
72 
			  			   sUserName IN LOGIN_TRAIL.USER_NAME%TYPE,
 787 
			  			   sUserName IN LOGIN_TRAIL.USER_NAME%TYPE,
73 
						   sClientIp IN LOGIN_TRAIL.CLIENT_IP%TYPE,
 788 
						   sClientIp IN LOGIN_TRAIL.CLIENT_IP%TYPE,
74 
						   nAppId IN LOGIN_TRAIL.APP_ID%TYPE,
 789 
						   nAppId IN LOGIN_TRAIL.APP_ID%TYPE,
Line 78... Line 793...
78 
	FUNCTION Get_Hash ( sText IN VARCHAR2 ) RETURN VARCHAR2;
793 
	FUNCTION Get_Hash ( sText IN VARCHAR2 ) RETURN VARCHAR2;
79 
 
 794 
 
80 
END pk_AMUtils;
 795 
END pk_AMUtils;
81 
 
 796 
 
82 
/
 797 
/
83 
 
 - 
 
84 
/
 - 
 
85 
--------------------------------------------------------
 798 
--------------------------------------------------------
86 
--  DDL for Package PK_APPLICATION
 799 
--  DDL for Package PK_APPLICATION
87 
--------------------------------------------------------
 800 
--------------------------------------------------------
88 
 
 801 
 
89 
  CREATE OR REPLACE PACKAGE "PK_APPLICATION" IS
 802 
  CREATE OR REPLACE PACKAGE "ACCESS_MANAGER"."PK_APPLICATION" IS
90 
 
 803 
 
91 
PROCEDURE Add_Application ( sAppName IN APPLICATIONS.APPLICATION_NAME%TYPE,
 804 
PROCEDURE Add_Application ( sAppName IN APPLICATIONS.APPLICATION_NAME%TYPE,
92 
		  				  	sAppAcronym IN APPLICATIONS.ACRONYM%TYPE );
 805 
		  				  	sAppAcronym IN APPLICATIONS.ACRONYM%TYPE );
93 
 
 806 
 
94 
PROCEDURE Remove_Application ( nAppId IN APPLICATIONS.APP_ID%TYPE );
807 
PROCEDURE Remove_Application ( nAppId IN APPLICATIONS.APP_ID%TYPE );
95
808
96 
 
 809 
 
97 
END pk_Application;
 810 
END pk_Application;
98 
 
 811 
 
99 
/
 812 
/
100 
 
 - 
 
101 
/
 - 
 
102 
--------------------------------------------------------
 813 
--------------------------------------------------------
103 
--  DDL for Package PK_CONTROL
 814 
--  DDL for Package PK_CONTROL
104 
--------------------------------------------------------
 815 
--------------------------------------------------------
105 
 
 816 
 
106 
  CREATE OR REPLACE PACKAGE "PK_CONTROL" IS
 817 
  CREATE OR REPLACE PACKAGE "ACCESS_MANAGER"."PK_CONTROL" IS
107 
 
 818 
 
108 
 
 819 
 
109 
PROCEDURE Add_Control ( sObjName IN CONTROL_OBJECTS.OBJ_NAME%TYPE,
 820 
PROCEDURE Add_Control ( sObjName IN CONTROL_OBJECTS.OBJ_NAME%TYPE,
110 
		  		   	  	sObjDescription IN CONTROL_OBJECTS.OBJ_DESCRIPTION%TYPE,
 821 
		  		   	  	sObjDescription IN CONTROL_OBJECTS.OBJ_DESCRIPTION%TYPE,
111 
					 	nAppId IN CONTROL_OBJECTS.APP_ID%TYPE
 822 
					 	nAppId IN CONTROL_OBJECTS.APP_ID%TYPE
112 
		  		   	 	);
823 
		  		   	 	);
- 
 
 824
- 
 
 825 
PROCEDURE Update_Control ( sObjId IN VARCHAR2,
- 
 
 826 
                sObjName IN CONTROL_OBJECTS.OBJ_NAME%TYPE,
- 
 
 827 
                sObjDescription IN CONTROL_OBJECTS.OBJ_DESCRIPTION%TYPE
- 
 
 828 
              );
113
829
114 
PROCEDURE Remove_Control ( sObjIdList IN VARCHAR2 );
830 
PROCEDURE Remove_Control ( sObjIdList IN VARCHAR2 );
115 
 
 831 
 
116
832
117 
PROCEDURE Set_Row_Permissions ( nDtId IN DATA_PERMISSIONS.DT_ID%TYPE,
 833 
PROCEDURE Set_Row_Permissions ( nDtId IN DATA_PERMISSIONS.DT_ID%TYPE,
Line 136... Line 852...
136 
 
 852 
 
137 
 
 853 
 
138 
END pk_Control;
 854 
END pk_Control;
139 
 
 855 
 
140 
/
 856 
/
141 
 
 - 
 
142 
/
 - 
 
143 
--------------------------------------------------------
 857 
--------------------------------------------------------
144 
--  DDL for Package PK_ROLE
 858 
--  DDL for Package PK_ROLE
145 
--------------------------------------------------------
 859 
--------------------------------------------------------
146 
 
 860 
 
147 
  CREATE OR REPLACE PACKAGE "PK_ROLE" IS
 861 
  CREATE OR REPLACE PACKAGE "ACCESS_MANAGER"."PK_ROLE" IS
148 
 
 862 
 
149 
 
 863 
 
150 
PROCEDURE Add_Role ( sRoleName IN ROLES.ROLE_NAME%TYPE,
 864 
PROCEDURE Add_Role ( sRoleName IN ROLES.ROLE_NAME%TYPE,
151 
		  		   	 sRoleComments IN ROLES.COMMENTS%TYPE,
 865 
		  		   	 sRoleComments IN ROLES.COMMENTS%TYPE,
152 
				   	 nAppId IN ROLES.APP_ID%TYPE  );
866 
				   	 nAppId IN ROLES.APP_ID%TYPE  );
Line 181... Line 895...
181
895
182 
PROCEDURE Revoke_Role ( sRoleIdList IN VARCHAR2,
 896 
PROCEDURE Revoke_Role ( sRoleIdList IN VARCHAR2,
183 
		  			    nUserId IN USER_ROLES.USER_ID%TYPE );
897 
		  			    nUserId IN USER_ROLES.USER_ID%TYPE );
184
898
185 
 
 899 
 
- 
 
 900 
  PROCEDURE Update_Role ( nRoleId IN ROLES.ROLE_ID%TYPE,
- 
 
 901 
                sRoleName IN ROLES.ROLE_NAME%TYPE,
- 
 
 902 
                sRoleComments IN ROLES.COMMENTS%TYPE
186 
END pk_Role;
 903 
              );
187 
 
 904 
 
188 
/
 905 
END pk_Role;
189 
 
 906 
 
190 
/
 907 
/
191 
--------------------------------------------------------
 908 
--------------------------------------------------------
192 
--  DDL for Package PK_SECURITY
 909 
--  DDL for Package PK_SECURITY
193 
--------------------------------------------------------
 910 
--------------------------------------------------------
194 
 
 911 
 
195 
  CREATE OR REPLACE PACKAGE "PK_SECURITY" IS
912 
  CREATE OR REPLACE PACKAGE "ACCESS_MANAGER"."PK_SECURITY" IS
196 
 
 913 
 
197 
/*
 914 
/*
198 
------------------------------
 915 
------------------------------
199 
||  Last Modified:  S.Vukovic
 916 
||  Last Modified:  S.Vukovic
200 
||  Modified Date:  28/Apr/2005
917 
||  Modified Date:  28/Apr/2005
Line 219... Line 936...
219 
	/*================================================================================================*/
 936 
	/*================================================================================================*/
220 
 
 937 
 
221 
END PK_SECURITY;
 938 
END PK_SECURITY;
222 
 
 939 
 
223 
/
 940 
/
224 
 
 - 
 
225 
/
 - 
 
226 
--------------------------------------------------------
 941 
--------------------------------------------------------
227 
--  DDL for Package PK_USER
 942 
--  DDL for Package PK_USER
228 
--------------------------------------------------------
 943 
--------------------------------------------------------
229 
 
 944 
 
230 
  CREATE OR REPLACE PACKAGE "PK_USER" IS
 945 
  CREATE OR REPLACE PACKAGE "ACCESS_MANAGER"."PK_USER" IS
231 
/*
 946 
/*
232 
------------------------------
 947 
------------------------------
233 
||  Last Modified:  J.Tweddle
 948 
||  Last Modified:  J.Tweddle
234 
||  Modified Date:  21/Jan/2008
 949 
||  Modified Date:  21/Jan/2008
235 
||  Spec Version:   2.1
 950 
||  Spec Version:   2.1
Line 268... Line 983...
268 
PROCEDURE Remove_User_Account ( sUserIdList IN VARCHAR2 );
 983 
PROCEDURE Remove_User_Account ( sUserIdList IN VARCHAR2 );
269
984
270 
END pk_user;
 985 
END pk_user;
271 
 
 986 
 
272 
/
 987 
/
273 
 
 - 
 
274 
/
 - 
 
275 
--------------------------------------------------------
 988 
--------------------------------------------------------
276 
--  DDL for Package Body PK_AMUTILS
 989 
--  DDL for Package Body PK_AMUTILS
277 
--------------------------------------------------------
 990 
--------------------------------------------------------
278 
 
 991 
 
279 
  CREATE OR REPLACE PACKAGE BODY "PK_AMUTILS"
992 
  CREATE OR REPLACE PACKAGE BODY "ACCESS_MANAGER"."PK_AMUTILS"
280 
IS
 993 
IS
281 
/* ---------------------------------------------------------------------------
 994 
/* ---------------------------------------------------------------------------
282 
    Version: 1.0.0
 995 
    Version: 1.0.0
283 
   --------------------------------------------------------------------------- */
 996 
   --------------------------------------------------------------------------- */
284 
 
 997 
 
Line 328... Line 1041...
328 
 
 1041 
 
329 
 
 1042 
 
330 
END pk_AMUtils;
 1043 
END pk_AMUtils;
331 
 
 1044 
 
332 
/
 1045 
/
333 
 
 - 
 
334 
/
 - 
 
335 
--------------------------------------------------------
 1046 
--------------------------------------------------------
336 
--  DDL for Package Body PK_APPLICATION
 1047 
--  DDL for Package Body PK_APPLICATION
337 
--------------------------------------------------------
 1048 
--------------------------------------------------------
338 
 
 1049 
 
339 
  CREATE OR REPLACE PACKAGE BODY "PK_APPLICATION"
1050 
  CREATE OR REPLACE PACKAGE BODY "ACCESS_MANAGER"."PK_APPLICATION"
340 
IS
 1051 
IS
341 
/* ---------------------------------------------------------------------------
 1052 
/* ---------------------------------------------------------------------------
342 
    Version: 1.0.0
 1053 
    Version: 1.0.0
343 
   --------------------------------------------------------------------------- */
 1054 
   --------------------------------------------------------------------------- */
344 
 
 1055 
 
Line 431... Line 1142...
431 
 
 1142 
 
432 
 
 1143 
 
433 
END pk_Application;
 1144 
END pk_Application;
434 
 
 1145 
 
435 
/
 1146 
/
436 
 
 - 
 
437 
/
 - 
 
438 
--------------------------------------------------------
 1147 
--------------------------------------------------------
439 
--  DDL for Package Body PK_CONTROL
 1148 
--  DDL for Package Body PK_CONTROL
440 
--------------------------------------------------------
 1149 
--------------------------------------------------------
441 
 
 1150 
 
442 
  CREATE OR REPLACE PACKAGE BODY "PK_CONTROL"
1151 
  CREATE OR REPLACE PACKAGE BODY "ACCESS_MANAGER"."PK_CONTROL"
443 
IS
 1152 
IS
444 
/* ---------------------------------------------------------------------------
 1153 
/* ---------------------------------------------------------------------------
445 
    Version: 1.0.0
 1154 
    Version: 1.0.0
446 
   --------------------------------------------------------------------------- */
 1155 
   --------------------------------------------------------------------------- */
447 
 
 1156 
 
Line 500... Line 1209...
500 
	THEN
1209 
	THEN
501 
		RAISE_APPLICATION_ERROR (-20000, 'Control Name '|| sObjName ||' is already used in this Application.');
 1210 
		RAISE_APPLICATION_ERROR (-20000, 'Control Name '|| sObjName ||' is already used in this Application.');
502 
 
 1211 
 
503
1212
504 
END	Add_Control;
 1213 
END	Add_Control;
- 
 
 1214 
 
- 
 
 1215 
/*--------------------------------------------------------------------------------------------------*/
- 
 
 1216 
PROCEDURE Update_Control ( sObjId IN VARCHAR2,
- 
 
 1217 
                sObjName IN CONTROL_OBJECTS.OBJ_NAME%TYPE,
- 
 
 1218 
                sObjDescription IN CONTROL_OBJECTS.OBJ_DESCRIPTION%TYPE
- 
 
 1219 
              ) IS
- 
 
 1220 
BEGIN
- 
 
 1221 
	/*--------------- Business Rules Here -------------------*/
- 
 
 1222 
	IF (sObjId IS NULL) THEN
- 
 
 1223 
	   RAISE_APPLICATION_ERROR (-20000, 'Please select a Control.' );
- 
 
 1224 
	END IF;
- 
 
 1225 
	/*-------------------------------------------------------*/
- 
 
 1226
- 
 
 1227 
        -- Update CONTROL
- 
 
 1228 
	UPDATE CONTROL_OBJECTS SET
- 
 
 1229 
	OBJ_NAME = sObjName, OBJ_DESCRIPTION = sObjDescription
- 
 
 1230 
	WHERE OBJ_ID = sObjId;
- 
 
 1231
- 
 
 1232 
END     Update_Control;
- 
 
 1233 
 
505 
/*--------------------------------------------------------------------------------------------------*/
 1234 
/*--------------------------------------------------------------------------------------------------*/
506 
PROCEDURE Remove_Control ( sObjIdList IN VARCHAR2 ) IS
 1235 
PROCEDURE Remove_Control ( sObjIdList IN VARCHAR2 ) IS
507
1236
508 
rowCount NUMBER DEFAULT 0;
 1237 
rowCount NUMBER DEFAULT 0;
509
1238
Line 697... Line 1426...
697 
 
 1426 
 
698 
 
 1427 
 
699 
END pk_Control;
 1428 
END pk_Control;
700 
 
 1429 
 
701 
/
 1430 
/
702 
 
 - 
 
703 
/
 - 
 
704 
--------------------------------------------------------
 1431 
--------------------------------------------------------
705 
--  DDL for Package Body PK_ROLE
 1432 
--  DDL for Package Body PK_ROLE
706 
--------------------------------------------------------
 1433 
--------------------------------------------------------
707 
 
 1434 
 
708 
  CREATE OR REPLACE PACKAGE BODY "PK_ROLE"
1435 
  CREATE OR REPLACE PACKAGE BODY "ACCESS_MANAGER"."PK_ROLE"
709 
         IS
 1436 
         IS
710 
 
 1437 
 
711 
         /*--------------------------------------------------------------------------------------------------*/
 1438 
         /*--------------------------------------------------------------------------------------------------*/
712 
         PROCEDURE Add_Role ( sRoleName IN ROLES.ROLE_NAME%TYPE,
 1439 
         PROCEDURE Add_Role ( sRoleName IN ROLES.ROLE_NAME%TYPE,
713 
                              sRoleComments IN ROLES.COMMENTS%TYPE,
 1440 
                              sRoleComments IN ROLES.COMMENTS%TYPE,
Line 732... Line 1459...
732 
            WHEN DUP_VAL_ON_INDEX
 1459 
            WHEN DUP_VAL_ON_INDEX
733 
            THEN
 1460 
            THEN
734 
               RAISE_APPLICATION_ERROR (-20000, 'Role Name '|| sRoleName ||' is already used in this Application.');
 1461 
               RAISE_APPLICATION_ERROR (-20000, 'Role Name '|| sRoleName ||' is already used in this Application.');
735 
 
 1462 
 
736 
         END   Add_Role;
 1463 
         END   Add_Role;
- 
 
 1464
- 
 
 1465 
         /*--------------------------------------------------------------------------------------------------*/
- 
 
 1466 
         PROCEDURE Update_Role ( nRoleId IN ROLES.ROLE_ID%TYPE,
- 
 
 1467 
                sRoleName IN ROLES.ROLE_NAME%TYPE,
- 
 
 1468 
                sRoleComments IN ROLES.COMMENTS%TYPE
- 
 
 1469 
              ) IS
- 
 
 1470 
          BEGIN
- 
 
 1471 
          /*--------------- Business Rules Here -------------------*/
- 
 
 1472 
          IF (nRoleId IS NULL) THEN
- 
 
 1473 
             RAISE_APPLICATION_ERROR (-20000, 'Please select a Role.' );
- 
 
 1474 
          END IF;
- 
 
 1475 
          /*-------------------------------------------------------*/
- 
 
 1476
- 
 
 1477 
                -- Update ROLE
- 
 
 1478 
          UPDATE ROLES SET
- 
 
 1479 
          ROLE_NAME = sRoleName, ROLES.COMMENTS = sRoleComments
- 
 
 1480 
          WHERE ROLE_ID = nRoleId;
- 
 
 1481
- 
 
 1482 
          END   Update_Role;
- 
 
 1483
737 
         /*--------------------------------------------------------------------------------------------------*/
 1484 
         /*--------------------------------------------------------------------------------------------------*/
738 
         PROCEDURE Remove_Role ( sRoleIdList IN VARCHAR2 ) IS
 1485 
         PROCEDURE Remove_Role ( sRoleIdList IN VARCHAR2 ) IS
739 
 
 1486 
 
740 
         rowCount NUMBER DEFAULT 0;
 1487 
         rowCount NUMBER DEFAULT 0;
741 
 
 1488 
 
Line 816... Line 1563...
816 
            -- Get PermId for "Visible"
 1563 
            -- Get PermId for "Visible"
817 
            SELECT pt.PERM_ID INTO nPermId FROM PERMISSION_TYPES pt WHERE pt.PERM_NAME = 'enumACTIVE';
 1564 
            SELECT pt.PERM_ID INTO nPermId FROM PERMISSION_TYPES pt WHERE pt.PERM_NAME = 'enumACTIVE';
818 
 
 1565 
 
819 
            Delete_Role_Permission ( nRoleId, nObjId, nPermId );
 1566 
            Delete_Role_Permission ( nRoleId, nObjId, nPermId );
820 
 
 1567 
 
821 
            IF ( cIsActive IS NOT NULL ) AND ( cIsVisible <> 'N') THEN
 1568 
            IF cIsActive IS NOT NULL THEN
822 
 
 1569 
 
823 
               INSERT INTO ROLE_PRIVILEGES ( ROLE_ID, OBJ_ID, PERM_ID, PERM_VALUE )
 1570 
               INSERT INTO ROLE_PRIVILEGES ( ROLE_ID, OBJ_ID, PERM_ID, PERM_VALUE )
824 
               VALUES ( nRoleId, nObjId, nPermId, cIsActive );
 1571 
               VALUES ( nRoleId, nObjId, nPermId, cIsActive );
825 
 
 1572 
 
826 
            END IF;
 1573 
            END IF;
Line 861... Line 1608...
861 
            END IF;
 1608 
            END IF;
862 
            /*-------------------------------------------------------*/
 1609 
            /*-------------------------------------------------------*/
863 
 
 1610 
 
864 
            IF Is_Permissions_Changed( nRoleId, nObjId, cIsVisible, cIsActive ) THEN
 1611 
            IF Is_Permissions_Changed( nRoleId, nObjId, cIsVisible, cIsActive ) THEN
865 
 
 1612 
 
866 
               IF Is_Role_Variation ( nRoleId ) THEN
 1613 
               IF nRoleId is not NULL AND Is_Role_Variation ( nRoleId ) THEN
867 
                  --- Set this user role permissions ---
 1614 
                  --- Set this user role permissions ---
868 
                  Set_Role_Permissions ( nRoleId, nObjId, cIsVisible, cIsActive );
 1615 
                  Set_Role_Permissions ( nRoleId, nObjId, cIsVisible, cIsActive );
869 
 
 1616 
 
870 
 
 1617 
 
871 
                  --- Remove this user role for no permission settings ---
 1618 
                  --- Remove this user role for no permission settings ---
Line 1105... Line 1852...
1105 
         END   Revoke_Role;
 1852 
         END   Revoke_Role;
1106 
         /*--------------------------------------------------------------------------------------------------*/
 1853 
         /*--------------------------------------------------------------------------------------------------*/
1107 
         END pk_Role;
 1854 
         END pk_Role;
1108 
 
 1855 
 
1109 
/
 1856 
/
1110 
 
 - 
 
1111 
/
 - 
 
1112 
--------------------------------------------------------
 1857 
--------------------------------------------------------
1113 
--  DDL for Package Body PK_SECURITY
 1858 
--  DDL for Package Body PK_SECURITY
1114 
--------------------------------------------------------
 1859 
--------------------------------------------------------
1115 
 
 1860 
 
1116 
  CREATE OR REPLACE PACKAGE BODY "PK_SECURITY" IS
1861 
  CREATE OR REPLACE PACKAGE BODY "ACCESS_MANAGER"."PK_SECURITY" IS
1117 
 
 1862 
 
1118 
/*
 1863 
/*
1119 
------------------------------
 1864 
------------------------------
1120 
||  Last Modified:  S.Vukovic
 1865 
||  Last Modified:  S.Vukovic
1121 
||  Modified Date:  28/Apr/2005
1866 
||  Modified Date:  28/Apr/2005
Line 1231... Line 1976...
1231 
 
 1976 
 
1232 
	OPEN RecordSet FOR
 1977 
	OPEN RecordSet FOR
1233 
	SELECT qry.TABLE_NAME,
 1978 
	SELECT qry.TABLE_NAME,
1234 
	 	   qry.REF_COLUMN_VAL,
 1979 
	 	   qry.REF_COLUMN_VAL,
1235 
	 	   qry.PERM_ID,
 1980 
	 	   qry.PERM_ID,
1236 
	 	   qry.PERM_VALUE
 1981 
	 	   qry.PERM_VALUE,
- 
 
 1982 
       co.OBJ_NAME
1237 
	  FROM CONTROL_OBJECTS co,
 1983 
	  FROM CONTROL_OBJECTS co,
1238 
		   DATA_TABLES dt,
 1984 
		   DATA_TABLES dt,
1239 
			(
 1985 
			(
1240
1986
1241 
			/* Access Control Data Permissions */
1987 
			/* Access Control Data Permissions */
1242 
			 SELECT bl.DT_ID,
 1988 
			 SELECT bl.DT_ID,
1243 
			 		bl.TABLE_NAME,
 1989 
			 		bl.TABLE_NAME,
1244 
			 		bl.REF_COLUMN_VAL,
 1990 
			 		bl.REF_COLUMN_VAL,
1245 
			 		bl.PERM_ID,
 1991 
			 		bl.PERM_ID,
1246 
			 		DECODE ( yc.PERM_VALUE,
 - 
 
1247 
			 	 		   	 NULL, bl.PERM_VALUE,
 - 
 
1248 
			 			 	 yc.PERM_VALUE ) AS PERM_VALUE
 1992 
			 		DECODE ( yc.PERM_VALUE, NULL, bl.PERM_VALUE, yc.PERM_VALUE ) AS PERM_VALUE
1249 
			  FROM (
 1993 
			  FROM (
1250 
			       	/* Get base list for Data Permissions */
1994 
			       	/* Get base list for Data Permissions */
1251 
				 	SELECT rol.ROLE_ID, dt.DT_ID, dt.TABLE_NAME, 0 AS REF_COLUMN_VAL, pt.PERM_ID, 'Y' AS PERM_VALUE
1995 
				 	SELECT rol.ROLE_ID, dt.DT_ID, dt.TABLE_NAME, 0 AS REF_COLUMN_VAL, pt.PERM_ID, 'Y' AS PERM_VALUE
1252 
				 	  FROM CONTROL_OBJECTS co,
 1996 
				 	  FROM CONTROL_OBJECTS co,
1253 
				 	  	   DATA_TABLES dt,
 1997 
				 	  	   DATA_TABLES dt,
1254 
				 		   PERMISSION_TYPES pt,
 1998 
				 		   PERMISSION_TYPES pt,
- 
 
 1999 
               DATA_PERMISSIONS dp,
1255 
				 		   (
 2000 
				 		   (
1256 
				 		    /* Get User Roles for this Application */
 2001 
				 		    /* Get User Roles for this Application */
1257 
				 		    SELECT ro.*
 2002 
				 		    SELECT ro.*
1258 
				 			  FROM ROLES ro,
 2003 
				 			  FROM ROLES ro,
1259 
				 			  	   USER_ROLES ur
 2004 
				 			  	   USER_ROLES ur
1260 
				 			 WHERE ur.ROLE_ID = ro.ROLE_ID
 2005 
				 			 WHERE ur.ROLE_ID = ro.ROLE_ID
1261 
				 			   --AND ro.APP_ID = AppId
 2006 
				 			   --AND ro.APP_ID = AppId
1262 
				 			   AND ur.USER_ID = UsedId
 2007 
				 			   AND ur.USER_ID = UsedId
1263 
				 		   ) rol
 2008 
				 		   ) rol
1264 
				 	 WHERE dt.OBJ_ID = co.OBJ_ID
 2009 
				 	 WHERE dt.OBJ_ID = co.OBJ_ID
- 
 
 2010 
           AND dp.DT_ID = dt.DT_ID
- 
 
 2011 
           AND dp.ROLE_ID = rol.ROLE_ID
1265 
				 	   --AND co.APP_ID = AppId
 2012 
				 	   --AND co.APP_ID = AppId
1266 
			  	   ) bl,
 2013 
			  	   ) bl,
1267 
			       (
 2014 
			       (
1268 
			 		 /* Find only 'Y' Permissions, which will change 'All' permission to 'N' */
 2015 
			 		 /* Find only 'Y' Permissions, which will change 'All' permission to 'N' */
1269 
			 		 SELECT dt.DT_ID, 0 AS REF_COLUMN_VAL, dp.PERM_ID, 'N' AS PERM_VALUE, COUNT(*) AS YES_COUNT
2016 
			 		 SELECT dt.DT_ID, 0 AS REF_COLUMN_VAL, dp.PERM_ID, 'N' AS PERM_VALUE, COUNT(*) AS YES_COUNT
Line 1318... Line 2065...
1318 
			) qry
 2065 
			) qry
1319 
	  WHERE dt.OBJ_ID = co.OBJ_ID
 2066 
	  WHERE dt.OBJ_ID = co.OBJ_ID
1320 
		AND dt.DT_ID = qry.DT_ID;
 2067 
		AND dt.DT_ID = qry.DT_ID;
1321 
		--AND co.APP_ID = AppId;
 2068 
		--AND co.APP_ID = AppId;
1322 
 
 2069 
 
1323 
 
 - 
 
1324 
END;
 2070 
END;
1325 
/*-------------------------------------------------------------------------------------------------------*/
 2071 
/*-------------------------------------------------------------------------------------------------------*/
1326 
END PK_SECURITY;
 2072 
END PK_SECURITY;
1327 
 
 2073 
 
1328 
/
 2074 
/
1329 
 
 - 
 
1330 
/
 - 
 
1331 
--------------------------------------------------------
 2075 
--------------------------------------------------------
1332 
--  DDL for Package Body PK_USER
 2076 
--  DDL for Package Body PK_USER
1333 
--------------------------------------------------------
 2077 
--------------------------------------------------------
1334 
 
 2078 
 
1335 
  CREATE OR REPLACE PACKAGE BODY "PK_USER" IS
 2079 
  CREATE OR REPLACE PACKAGE BODY "ACCESS_MANAGER"."PK_USER" IS
1336 
/*
 2080 
/*
1337 
------------------------------
 2081 
------------------------------
1338 
||  Last Modified:  J.Tweddle
 2082 
||  Last Modified:  J.Tweddle
1339 
||  Modified Date:  21/Jan/2008
2083 
||  Modified Date:  21/Jan/2008
1340 
||  Body Version:   2.1
 2084 
||  Body Version:   2.1
Line 1658... Line 2402...
1658 
END	Remove_User_Account;
 2402 
END	Remove_User_Account;
1659 
/*--------------------------------------------------------------------------------------------------*/
 2403 
/*--------------------------------------------------------------------------------------------------*/
1660 
END pk_user;
 2404 
END pk_user;
1661 
 
 2405 
 
1662 
/
 2406 
/
- 
 
 2407 
--------------------------------------------------------
- 
 
 2408 
--  DDL for Synonymn DM_DEF_MENU_ITEMS
- 
 
 2409 
--------------------------------------------------------
1663 
 
 2410 
 
- 
 
 2411 
  CREATE OR REPLACE SYNONYM "ACCESS_MANAGER"."DM_DEF_MENU_ITEMS" FOR "DM_DEV"."DEF_MENU_ITEMS";
- 
 
 2412 
--------------------------------------------------------
- 
 
 2413 
--  DDL for Synonymn DM_DM_PROJECTS
- 
 
 2414 
--------------------------------------------------------
1664 
/
 2415 
 
- 
 
 2416 
  CREATE OR REPLACE SYNONYM "ACCESS_MANAGER"."DM_DM_PROJECTS" FOR "DEPLOYMENT_MANAGER"."DM_PROJECTS";
- 
 
 2417 
--------------------------------------------------------
- 
 
 2418 
--  DDL for Synonymn PM_DM_PROJECTS
- 
 
 2419 
--------------------------------------------------------
- 
 
 2420 
 
- 
 
 2421 
  CREATE OR REPLACE SYNONYM "ACCESS_MANAGER"."PM_DM_PROJECTS" FOR "DEPLOYMENT_MANAGER"."DM_PROJECTS";
- 
 
 2422 
--------------------------------------------------------
- 
 
 2423 
--  DDL for Synonymn PROJECTS
- 
 
 2424 
--------------------------------------------------------
- 
 
 2425 
 
- 
 
 2426 
  CREATE OR REPLACE SYNONYM "ACCESS_MANAGER"."PROJECTS" FOR "RELEASE_MANAGER"."PROJECTS";
- 
 
 2427 
--------------------------------------------------------
- 
 
 2428 
--  DDL for Synonymn RM_PROJECTS
- 
 
 2429 
--------------------------------------------------------
- 
 
 2430 
 
- 
 
 2431 
  CREATE OR REPLACE SYNONYM "ACCESS_MANAGER"."RM_PROJECTS" FOR "RELEASE_MANAGER"."PROJECTS";