CREATE TABLE OWB_ROLE_INFO(       
       repository_name VARCHAR2(30) unique, 
       public_view_role_name VARCHAR2(30),
       owb_user_role_name VARCHAR2(30),
       owb_user_role_enabling_pwd RAW(2000)
);
create table USER_LOGIN_INFO(
user_name varchar2(30) not null,  
inst_id number  not null, 
sid number not null, 
SERIAL# NUMBER not null, 
logon_time VARCHAR2(30) not null, 
osUser VARCHAR2(512) not null,
workspaceId number not null
);
 ALTER  ROLE OWBM$CLIENT IDENTIFIED by %pwd; 
ALTER ROLE OWBM_DESIGNCENTER_VIEW IDENTIFIED by %pwd;
create type SEC_STRINGLIST AS VARRAY(200) OF VARCHAR2(200);
CREATE TYPE SEC_OBJECTINFOLIST IS VARRAY(1000) OF  VARCHAR2(400);
create type SEC_INTEGERLIST AS VARRAY(500) OF NUMBER(9);
create type SEC_UOIDLIST AS VARRAY(500) OF VARCHAR2(255);
create table FCO_READ_LOOKUP(
	FCOID number(9), 
	privilegeOwnerID number(9));
create index IDX_FCO_READ_LOOKUP_PRIVID on
FCO_READ_LOOKUP(privilegeOwnerID) PARALLEL NOLOGGING COMPRESS
tablespace %tndex;	
create index IDX_FCO_READ_LOOKUP_FCOID on
FCO_READ_LOOKUP(FCOID) PARALLEL NOLOGGING COMPRESS
tablespace %tndex;	
create table SYS_PRIV_ID_TO_NAME_TAB(
	sysPrivId number(9) unique, 	
	sysPrivName varchar2(200) unique);	
CREATE or replace TYPE priv_t wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
d
9200000
1
4
0 
6
2 :e:
1TYPE:
1PRIV_T:
1OBJECT:
1NAME:
1VARCHAR2:
1100:
0

0
0
14
2
0 a0 9d a0 60 a3 a0 51
a5 1c b0 81 77 a0 102 a0
c6 1d 17 b5 
14
2
0 3 3f b f 33 23 27
2a 2b 22 3a 7 46 1f 4a
4e 50 51 5a 
14
2
0 1 6 10 1 3 8 11
10 8 :2 3 1 :2 16 :5 1 
14
4
0 :4 1 :7 2 1
:2 2 :5 1 
5c
4
:3 0 1 :3 0 2
0 4 0 3
:3 0 7 :3 0 e
1 c :9 0 d
:2 0 :2 5 :3 0 6
:2 0 3 6 8
:6 0 4 :6 0 a
9 0 4 0
2 4 2 1
:3 0 2 :3 0 2
:2 0 2 f c
0 11 10 13
:8 0 
9
4
:3 0 1 7 1
5 1 b 
1
4
0 
12
0
1
14
1
2
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
5 1 0
2 0 1
0

/
create or replace type privList as table of priv_t;
/
create table OBJ_PRIV_ID_TO_NAME_TAB(
	objPrivId number(9) unique, 	
	objPrivName varchar2(200) unique);	
create table obsolete_sys_privs(obsolete_sys_name varchar2(255));
insert into obsolete_sys_privs(obsolete_sys_name) values('CREATE_USER');
insert into obsolete_sys_privs(obsolete_sys_name) values('CREATE_ROLE');
insert into obsolete_sys_privs(obsolete_sys_name) values('CREATE_ACLCONTAINER');
insert into obsolete_sys_privs(obsolete_sys_name) values('SNAPSHOT_RESTORE');
insert into obsolete_sys_privs(obsolete_sys_name) values('RUNTIME_EXECUTE');
insert into obsolete_sys_privs(obsolete_sys_name) values('SOURCE_IMPORT');
insert into obsolete_sys_privs(obsolete_sys_name) values('BRIDGE_EXPORT');
insert into obsolete_sys_privs(obsolete_sys_name) values('BRIDGE_IMPORT');
insert into obsolete_sys_privs(obsolete_sys_name) values('MDL_EXPORT');
insert into obsolete_sys_privs(obsolete_sys_name) values('MDL_IMPORT');
insert into obsolete_sys_privs(obsolete_sys_name) values('DEPLOY');
insert into obsolete_sys_privs(obsolete_sys_name) values('DEPLOYMENT_TARGET_USER');
insert into obsolete_sys_privs(obsolete_sys_name) values('CREATE_MIVDEFINITION');
insert into obsolete_sys_privs(obsolete_sys_name) values('CONTROL_CENTER_EXECUTE');
insert into obsolete_sys_privs(obsolete_sys_name) values('CONTROL_CENTER_DEPLOY');
insert into obsolete_sys_privs(obsolete_sys_name) values('CONTROL_CENTER_ADMIN');
commit;
create table obsolete_obj_privs(obsolete_obj_name varchar2(255));
insert into obsolete_obj_privs(obsolete_obj_name) values('CREATE');
insert into obsolete_obj_privs(obsolete_obj_name) values('DELETE');
insert into obsolete_obj_privs(obsolete_obj_name) values('REFERENCE');
insert into obsolete_obj_privs(obsolete_obj_name) values('VERSION');
insert into obsolete_obj_privs(obsolete_obj_name) values('GENERATION');
insert into obsolete_obj_privs(obsolete_obj_name) values('VALIDATE');
commit;
CREATE OR REPLACE PACKAGE SECURITY_PV_UTILITIES wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
9
9200000
1
4
0 
10
2 :e:
1PACKAGE:
1SECURITY_PV_UTILITIES:
1FUNCTION:
1CUR_USERID:
1RETURN:
1NUMBER:
1IS_CUR_USER_ADMIN:
1GETSYSPRIVNAMES:
1ACCESSCHARSET:
1VARCHAR2:
1PRIVLIST:
1PIPELINED:
1GETOBJPRIVNAMES:
1GRANT_ACCESS_PUBLICVIEW_PRIV:
1GRANTING:
1USERNAME:
0

0
0
3f
2
0 a0 97 a0 8d a0 b4 a0
2c 6a a0 8d a0 b4 a0 2c
6a a0 8d 8f a0 b0 3d b4
:3 a0 12b 2c 6a a0 8d 8f a0
b0 3d b4 :3 a0 12b 2c 6a 9a
8f a0 b0 3d 8f a0 b0 3d
b4 55 6a a0 :2 aa 59 58 1d
17 b5 
3f
2
0 3 7 11 15 29 2d 2e
32 36 3a 3e 52 56 57 5b
5f 63 67 83 7f 7e 8b 7b
90 94 98 9c a1 a5 a9 ad
c9 c5 c4 d1 c1 d6 da de
e2 e7 eb ef 10b 107 106 113
120 11c 103 128 11b 12d 131 135
118 139 13b 13e 141 142 14b 
3f
2
0 1 9 1 a 15 0 1c
:3 1 a 1c 0 23 :3 1 b 1b
29 :2 1b 1a 33 3a :2 43 :3 1 b
1b 29 :2 1b 1a 33 3a :2 43 :2 1
b 28 31 :2 28 39 42 :2 39 27
:2 1 5 :7 1 
3f
4
0 :2 1 :3 3 0
:3 3 :3 4 0 :3 4
:d 5 :d 6 :c 7 9
:7 1 
14d
4
:3 0 1 :3 0 2
:6 0 1 :2 0 3
:3 0 4 :a 0 9
2 :7 0 5 :4 0
6 :3 0 6 7
0 9 4 8
0 38 3 :3 0
7 :a 0 10 3
:7 0 5 :4 0 6
:3 0 d e 0
10 b f 0
38 3 :3 0 8
:a 0 1d 4 400
:3 0 1b :2 0 5
:2 0 3 a :3 0
9 :7 0 15 14
:3 0 5 :3 0 b
:3 0 c :3 0 400
:4 0 17 19 0
1d 12 1c 0
38 3 :3 0 d
:a 0 2a 5 400
:3 0 28 :2 0 9
:2 0 7 a :3 0
9 :7 0 22 21
:3 0 5 :3 0 b
:3 0 c :3 0 400
:4 0 24 26 0
2a 1f 29 0
38 e :a 0 36
6 :7 0 d 118
0 b 6 :3 0
f :7 0 2e 2d
:3 0 12 3a 0
f a :3 0 10
:7 0 32 31 :3 0
34 :2 0 36 2b
35 0 38 2
:4 0 3a 38 39
3b 2 3a 3d
0 3c 3b 3e
:8 0 
18
4
:3 0 1 13 1
16 1 20 1
23 1 2c 1
30 2 2f 33
5 9 10 1d
2a 36 
1
4
0 
3d
0
1
14
6
a
0 1 1 1 1 1 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
2b 1 6
20 5 0
13 4 0
30 6 0
1f 1 5
2 0 1
2c 6 0
4 1 2
12 1 4
b 1 3
0

/
CREATE OR REPLACE PACKAGE BODY SECURITY_PV_UTILITIES wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0 
5e
2 :e:
1PACKAGE:
1BODY:
1SECURITY_PV_UTILITIES:
1M_ISUSERINFOINITED:
1NUMBER:
10:
1M_USERID:
1M_ISUSERADMIN:
1INIT:
1THEUSERNAME:
1VARCHAR2:
130:
1USER:
1DUAL:
1ELEMENTID:
1CMPWBUSER_V:
1UPPER:
1NAME:
1=:
1COUNT:
1CMPWBROLE_V:
1R:
1CMPROLEASSIGNMENT_V:
1A:
1WBUSER:
1WBROLE:
1ISADMIN:
11:
1OTHERS:
1RAISE_APPLICATION_ERROR:
1-:
120001:
1SECURITY_PV_UTILITIES found the SQL error:::
1||:
1SUBSTR:
1SQLERRM:
1200:
1FUNCTION:
1IS_CUR_USER_ADMIN:
1RETURN:
1CUR_USERID:
1GETSYSPRIVNAMES:
1ACCESSCHARSET:
1PRIVLIST:
1PIPELINED:
1INPUT_LEN:
1SYS_ID:
1SYS_NAME:
1255:
1BITCHAR:
1CHAR:
1MAX_SYS_ID:
1ISOBSOLETE:
1IS NULL:
1LENGTH:
1MAX:
1SYSPRIVID:
1SYS_PRIV_ID_TO_NAME_TAB:
1I:
1LOOP:
1EXIT:
1>:
1+:
1SYSPRIVNAME:
1OBSOLETE_SYS_PRIVS:
1OBSOLETE_SYS_NAME:
1PIPE:
1ROW:
1PRIV_T:
1NO_DATA_FOUND:
1SecurityPublicViewUtil found the SQL error:::
1GETOBJPRIVNAMES:
1OBJ_ID:
1OBJ_NAME:
1MAX_OBJ_ID:
1OBJPRIVID:
1OBJ_PRIV_ID_TO_NAME_TAB:
1OBJPRIVNAME:
1OBSOLETE_OBJ_PRIVS:
1OBSOLETE_OBJ_NAME:
120000:
1GRANT_ACCESS_PUBLICVIEW_PRIV:
1GRANTING:
1USERNAME:
1STMT:
12000:
1revoke EXECUTE on start_access_publicview from :
1grant EXECUTE on start_access_publicview to :
1EXECUTE:
1IMMEDIATE:
1SQLCODE:
1!=:
11927:
120002:
0

0
0
309
2
0 :2 a0 97 a3 a0 1c 51 81
b0 a3 a0 1c 51 81 b0 a3
a0 1c 51 81 b0 9a b4 55
6a a3 a0 51 a5 1c 81 b0
a0 ac :2 a0 b2 ee ac e5 d0
b2 e9 a0 ac :2 a0 b2 ee :2 a0
a5 b a0 7e a0 a5 b b4
2e ac e5 d0 b2 e9 a0 d2
9f ac :3 a0 b9 :2 a0 b9 b2 ee
:2 a0 6b a0 7e b4 2e :2 a0 6b
a0 7e a0 6b b4 2e a 10
:2 a0 6b 7e 6e b4 2e a 10
ac e5 d0 b2 e9 a0 51 d
b7 a0 53 a0 7e 51 b4 2e
6e 7e :2 a0 :2 51 a5 b b4 2e
a5 57 b7 a6 9 a4 a0 b1
11 68 4f a0 8d a0 b4 a0
2c 6a a0 7e 51 b4 2e 5a
a0 57 b3 b7 19 3c :2 a0 65
b7 a0 53 a0 7e 51 b4 2e
6e 7e :2 a0 :2 51 a5 b b4 2e
a5 57 b7 a6 9 a4 a0 b1
11 68 4f a0 8d a0 b4 a0
2c 6a a0 7e 51 b4 2e 5a
a0 57 b3 b7 19 3c :2 a0 65
b7 a0 53 a0 7e 51 b4 2e
6e 7e :2 a0 :2 51 a5 b b4 2e
a5 57 b7 a6 9 a4 a0 b1
11 68 4f a0 8d 8f a0 b0
3d b4 :3 a0 12b 2c 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 51 a5 1c 81 b0 a3
a0 51 a5 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 81 b0
a0 7e b4 2e 5a a0 65 b7
19 3c :3 a0 a5 b d a0 9f
a0 d2 ac :2 a0 b2 ee ac e5
d0 b2 e9 91 51 :2 a0 63 37
:2 a0 7e a0 7e 51 b4 2e 5a
b4 2e 2b :4 a0 51 a5 b d
a0 7e 6e b4 2e 5a 4f b7
:2 a0 ac :3 a0 b2 ee :2 a0 :2 7e 51
b4 2e b4 2e ac e5 d0 b2
e9 a0 d2 9f ac :2 a0 b2 ee
:2 a0 7e b4 2e ac e5 d0 b2
e9 a0 7e 51 b4 2e 5a 4f
b7 :4 a0 a5 b 129 b7 :2 19 3c
b7 a0 4f b7 a6 9 a4 b1
11 4f b7 :2 19 3c b7 a0 47
b7 a0 53 a0 7e 51 b4 2e
6e 7e :2 a0 :2 51 a5 b b4 2e
a5 57 b7 a6 9 a4 a0 b1
11 68 4f a0 8d 8f a0 b0
3d b4 :3 a0 12b 2c 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 51 a5 1c 81 b0 a3
a0 51 a5 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 81 b0
a0 7e b4 2e 5a a0 65 b7
19 3c :3 a0 a5 b d a0 9f
a0 d2 ac :2 a0 b2 ee ac e5
d0 b2 e9 91 51 :2 a0 63 37
:2 a0 7e a0 7e 51 b4 2e 5a
b4 2e 2b :4 a0 51 a5 b d
a0 7e 6e b4 2e 5a 4f b7
:2 a0 ac :3 a0 b2 ee :2 a0 :2 7e 51
b4 2e b4 2e ac e5 d0 b2
e9 a0 d2 9f ac :2 a0 b2 ee
:2 a0 7e b4 2e ac e5 d0 b2
e9 a0 7e 51 b4 2e 5a 4f
b7 :4 a0 a5 b 129 b7 :2 19 3c
b7 a0 4f b7 a6 9 a4 b1
11 4f b7 :2 19 3c b7 a0 47
b7 a0 53 a0 7e 51 b4 2e
6e 7e :2 a0 :2 51 a5 b b4 2e
a5 57 b7 a6 9 a4 a0 b1
11 68 4f 9a 8f a0 b0 3d
8f a0 b0 3d b4 55 6a a3
a0 51 a5 1c 81 b0 a0 7e
51 b4 2e 5a a0 6e 7e a0
b4 2e d b7 a0 6e 7e a0
b4 2e d b7 :2 19 3c :3 a0 11e
11d b7 a0 53 a0 :2 7e 51 b4
2e b4 2e a0 7e 51 b4 2e
6e 7e :2 a0 :2 51 a5 b b4 2e
a5 57 b7 19 3c b7 a6 9
a4 a0 b1 11 68 4f b1 b7
a4 11 a0 b1 56 4f 1d 17
b5 
309
2
0 3 7 b 2d 19 1d 25
28 18 49 38 3c 15 44 37
65 54 58 34 60 53 6c 50
80 84 a1 8c 90 93 94 9c
8b a8 88 ac b0 b4 b5 bc
bd c3 c7 c8 cd d1 d2 d6
da db e2 e6 ea eb ed f1
f4 f8 f9 fb fc 101 102 108
10c 10d 112 116 11a 11d 11e 122
126 12a 12c 130 134 136 137 13e
142 146 149 14d 150 151 156 15a
15e 161 165 168 16c 16f 170 1
175 17a 17e 182 185 188 18d 18e
1 193 198 199 19f 1a3 1a4 1a9
1ad 1b0 1b4 1b6 1 1ba 1be 1c1
1c4 1c5 1ca 1cf 1d2 1d6 1da 1dd
1e0 1e1 1e3 1e4 1e9 1ea 1ef 1f1
1f2 1f7 1fb 1ff 201 20d 211 213
217 22b 22f 230 234 238 23c 240
243 246 247 24c 24f 253 258 259
25b 25f 262 266 26a 26e 270 1
274 278 27b 27e 27f 284 289 28c
290 294 297 29a 29b 29d 29e 2a3
2a4 2a9 2ab 2ac 2b1 2b5 2b9 2bb
2c7 2cb 2cd 2d1 2e5 2e9 2ea 2ee
2f2 2f6 2fa 2fd 300 301 306 309
30d 312 313 315 319 31c 320 324
328 32a 1 32e 332 335 338 339
33e 343 346 34a 34e 351 354 355
357 358 35d 35e 363 365 366 36b
36f 373 375 381 385 387 38b 3a7
3a3 3a2 3af 39f 3b4 3b8 3bc 3c0
3c5 3c9 3e2 3d1 3d5 3dd 3d0 3fe
3ed 3f1 3f9 3cd 41a 405 409 40c
40d 415 3ec 437 425 3e9 429 42a
432 424 453 442 446 44e 421 46b
45a 45e 466 441 472 43e 476 477
47c 47f 483 487 489 48d 490 494
498 49c 49d 49f 4a3 4a7 4aa 4ae
4b2 4b3 4b7 4bb 4bc 4c3 4c4 4ca
4ce 4cf 4d4 4d8 4db 4df 4e3 4e7
4e9 4ed 4f1 4f4 4f8 4fb 4fe 4ff
504 507 508 50d 513 517 51b 51f
523 526 527 529 52d 531 534 539
53a 53f 542 544 546 54a 54e 54f
553 557 55b 55c 563 567 56b 56e
571 574 575 57a 57b 580 581 587
58b 58c 591 595 599 59c 59d 5a1
5a5 5a6 5ad 5b1 5b5 5b8 5b9 5be
5bf 5c5 5c9 5ca 5cf 5d3 5d6 5d9
5da 5df 5e2 5e4 5e6 5ea 5ee 5f2
5f6 5f7 5f9 5fd 5ff 603 607 60a
60c 610 612 614 615 61a 61e 620
62c 62e 630 634 638 63b 63d 641
648 64a 1 64e 652 655 658 659
65e 663 666 66a 66e 671 674 675
677 678 67d 67e 683 685 686 68b
68f 693 695 6a1 6a5 6a7 6ab 6c7
6c3 6c2 6cf 6bf 6d4 6d8 6dc 6e0
6e5 6e9 702 6f1 6f5 6fd 6f0 71e
70d 711 719 6ed 73a 725 729 72c
72d 735 70c 757 745 709 749 74a
752 744 773 762 766 76e 741 78b
77a 77e 786 761 792 75e 796 797
79c 79f 7a3 7a7 7a9 7ad 7b0 7b4
7b8 7bc 7bd 7bf 7c3 7c7 7ca 7ce
7d2 7d3 7d7 7db 7dc 7e3 7e4 7ea
7ee 7ef 7f4 7f8 7fb 7ff 803 807
809 80d 811 814 818 81b 81e 81f
824 827 828 82d 833 837 83b 83f
843 846 847 849 84d 851 854 859
85a 85f 862 864 866 86a 86e 86f
873 877 87b 87c 883 887 88b 88e
891 894 895 89a 89b 8a0 8a1 8a7
8ab 8ac 8b1 8b5 8b9 8bc 8bd 8c1
8c5 8c6 8cd 8d1 8d5 8d8 8d9 8de
8df 8e5 8e9 8ea 8ef 8f3 8f6 8f9
8fa 8ff 902 904 906 90a 90e 912
916 917 919 91d 91f 923 927 92a
92c 930 932 934 935 93a 93e 940
94c 94e 950 954 958 95b 95d 961
968 96a 1 96e 972 975 978 979
97e 983 986 98a 98e 991 994 995
997 998 99d 99e 9a3 9a5 9a6 9ab
9af 9b3 9b5 9c1 9c5 9c7 9e3 9df
9de 9eb 9f8 9f4 9db a00 9f3 a05
a09 a23 a11 9f0 a15 a16 a1e a10
a2a a0d a2e a31 a32 a37 a3a a3e
a43 a46 a4a a4b a50 a54 a56 a5a
a5f a62 a66 a67 a6c a70 a72 a76
a7a a7d a81 a85 a89 a8e a92 a94
1 a98 a9c a9f aa2 aa5 aa6 aab
aac ab1 ab5 ab8 abb abc ac1 ac6
ac9 acd ad1 ad4 ad7 ad8 ada adb
ae0 ae1 ae6 ae8 aec aef af1 af2
af7 afb aff b01 b0d b11 b13 b15
b17 b1b b27 b2b b2d b30 b32 b33
b3c 
309
2
0 1 9 e 2 :2 15 1e 15
:2 2 :2 b 13 b :2 2 :2 10 19 10
2 b 0 :2 1 2 e 17 16
:2 e 2 :2 9 13 24 1f 24 1f
:4 2 :2 9 18 26 21 26 38 3e
:2 38 46 44 4c :2 46 :2 44 21 :4 2
:4 9 17 7 13 7 16 2a 16
2 7 8 :2 a 13 :3 11 8 :2 a
16 14 :2 18 :2 14 :2 8 f :2 11 19
1a :2 19 :2 8 :6 2 17 2 1 :2 7
4 1c 1d :2 1c 24 50 52 59
61 63 :2 52 :2 24 :2 4 e :2 2 1
5 :5 1 a 1c 0 23 :2 1 4
17 19 :2 17 3 :3 2 1c :3 1 8
:2 1 :2 7 4 1c 1d :2 1c 24 50
52 59 61 63 :2 52 :2 24 :2 4 e
:2 2 1 6 :5 1 a 15 0 1c
:2 1 4 17 19 :2 17 3 :3 2 1c
:3 1 8 :2 1 :2 7 4 1c 1d :2 1c
24 50 52 59 61 63 :2 52 :2 24
:2 4 e :2 2 1 6 :5 1 b 1b
29 :2 1b 1a 33 3a :2 43 :2 1 2
:3 c :2 2 :3 9 :2 2 b 14 13 :2 b
:2 2 a f e :2 a :2 2 :3 d :2 2
:3 d 2 :4 5 4 :2 2 1c :3 2 d
14 :2 d 2 :2 9 d :2 9 1d 2d
28 2d 28 :4 2 6 b e 18
b 2 5 f 11 14 1e 1f
:2 14 13 :2 11 :2 5 e 15 23 25
:2 e 5 8 f 10 :2 f 7 d
15 d 18 d 29 31 c 6
c 2a 36 34 37 38 :2 36 :2 34
:5 6 :4 d 1b e 26 e 27 3b
:3 39 26 :4 6 9 14 16 :2 14 8
7 19 f 14 18 1f :2 18 f
14 :3 6 d 16 b 24 :2 11 a
:4 6 :3 5 18 6 2 1 :2 8 2
1a 1b :2 1a 21 4e 50 57 5f
61 :2 50 :2 21 :2 2 f :2 3 1 5
:5 1 b 1b 29 :2 1b 1a 33 3a
:2 43 :2 1 2 :3 c :2 2 :3 9 :2 2 b
14 13 :2 b :2 2 a f e :2 a
:2 2 :3 d :2 2 :3 d 2 :4 5 4 :2 2
1c :3 2 d 14 :2 d 2 :2 9 d
:2 9 1d 2d 28 2d 28 :4 2 6
b e 18 b 2 5 f 11
14 1e 1f :2 14 13 :2 11 :2 5 e
15 23 25 :2 e 5 8 f 10
:2 f 7 d 15 d 18 d 29
31 c 6 c 2a 36 34 37
38 :2 36 :2 34 :5 6 :4 d 1b e 26
e 27 3b :3 39 26 :4 6 9 14
16 :2 14 8 7 19 f 14 18
1f :2 18 f 14 :3 6 d 16 b
24 :2 11 a :4 6 :3 5 18 6 2
1 :2 8 2 1a 1b :2 1a 21 4e
50 57 5f 61 :2 50 :2 21 :2 2 f
:2 3 1 5 :4 1 b 28 31 :2 28
39 42 :2 39 27 :3 1 6 f e
:2 6 1 a 13 15 :2 13 9 4
b 3c 3e :2 b 4 18 5 b
39 3b :2 b 5 2 :3 7 6 e
19 :2 6 1 :2 7 6 e 11 12
:2 11 :2 e 2 1a 1b :2 1a 21 4e
50 57 5f 61 :2 50 :2 21 :2 2 a
:2 3 e :2 2 1 5 :8 1 5 :6 1

309
4
0 :3 1 :6 2 :6 3
:6 4 6 0 :2 6
:7 8 :b a :16 b :5 e
:8 f :7 10 :9 11 :2 10
:7 12 :2 10 f :4 e
:3 14 9 :2 17 :11 18
:3 17 16 1a :4 6
:3 1c 0 :3 1c :6 21
:3 23 :3 21 :3 27 20
:2 2a :11 2b :3 2a 29
2d :4 1c :3 31 0
:3 31 :6 36 :3 38 :3 36
:3 3c 35 :2 3f :11 40
:3 3f 3e 42 :4 31
:d 46 :5 48 :5 49 :7 4a
:7 4b :5 4c :5 4d :5 52
:2 55 :3 52 :6 58 :e 59
:6 5b :c 5c :8 5d :6 5f
60 5f :5 64 :d 65
:4 64 :5 67 68 67
:6 68 :5 67 :6 69 6a
69 :7 6d 6c :3 69
62 70 71 :3 70
6f :4 61 :3 5f 5b
74 5b 4e :2 78
:11 79 :3 78 77 7b
:4 46 :d 7e :5 80 :5 81
:7 82 :7 83 :5 84 :5 85
:5 8a :2 8d :3 8a :6 90
:e 91 :6 93 :c 94 :8 95
:6 97 98 97 :5 9c
:d 9d :4 9c :5 9f a0
9f :6 a0 :5 9f :6 a1
a2 a1 :7 a5 a4
:3 a1 9a a8 a9
:3 a8 a7 :4 99 :3 97
93 ac 93 86
:2 b0 :11 b1 :3 b0 af
b3 :4 7e :c b5 :7 b8
:6 bb :7 bd bb :7 bf
be :3 bb :5 c2 ba
:2 c5 :8 c6 :11 c8 c7
:2 c6 :3 c5 c4 ca
:4 b5 :4 6 ce :6 1

b3e
4
:3 0 1 :3 0 2
:3 0 3 :6 0 1
:2 0 6 :2 0 3
5 :3 0 5 :7 0
6 :2 0 9 6
7 303 0 4
:6 0 6 :2 0 :2 5
:3 0 b :7 0 f
c d 303 0
7 :9 0 7 5
:3 0 11 :7 0 15
12 13 303 0
8 :6 0 9 :a 0
8d 2 :7 0 17
:2 0 8d 16 18
:2 0 d :2 0 :2 b
:3 0 c :2 0 9
1b 1d :6 0 20
1e 0 8b 0
a :6 0 d :3 0
a :3 0 e :3 0
f 25 :2 0 27
:4 0 29 2a :5 0
22 26 0 11
0 28 :2 0 72
f :3 0 13 7
:3 0 10 :3 0 15
30 3c 0 3d
:3 0 11 :3 0 12
:3 0 17 32 34
11 :3 0 13 :2 0
a :3 0 19 36
39 1d 37 3b
:4 0 3f 40 :5 0
2d 31 0 20
0 3e :2 0 72
14 :3 0 44 :3 0
14 :2 0 22 8
:3 0 15 :3 0 16
:3 0 47 48 17
:3 0 18 :3 0 4a
4b 24 4d 69
0 6a :3 0 18
:3 0 19 :3 0 4f
50 0 7 :3 0
13 :2 0 29 53
54 :3 0 16 :3 0
f :3 0 56 57
0 18 :3 0 13
:2 0 1a :3 0 59
5b 0 2e 5a
5d :3 0 55 5f
5e :2 0 16 :3 0
1b :3 0 61 62
0 13 :2 0 1c
:4 0 33 64 66
:3 0 60 68 67
:3 0 6c 6d :5 0
45 4e 0 36
0 6b :2 0 72
4 :3 0 1c :2 0
6f 70 0 72
38 8c 1d :3 0
1e :3 0 1f :2 0
20 :2 0 3d 76
78 :3 0 21 :4 0
22 :2 0 23 :3 0
24 :3 0 1c :2 0
25 :2 0 3f 7c
80 43 7b 82
:3 0 46 75 84
:2 0 86 49 88
4b 87 86 :2 0
89 4d :2 0 8c
9 :3 0 4f 8c
8b 72 89 :6 0
8d 1 0 16
18 8c 303 :2 0
26 :3 0 27 :a 0
c0 3 :7 0 28
:4 0 5 :3 0 92
93 0 c0 90
94 :2 0 4 :3 0
13 :2 0 6 :2 0
53 97 99 :3 0
9a :2 0 9 :3 0
9c 9e :2 0 9f
0 56 a0 9b
9f 0 a1 58
0 a5 28 :3 0
8 :3 0 a3 :2 0
a5 5a bf 1d
:3 0 1e :3 0 1f
:2 0 20 :2 0 5d
a9 ab :3 0 21
:4 0 22 :2 0 23
:3 0 24 :3 0 1c
:2 0 25 :2 0 5f
af b3 63 ae
b5 :3 0 66 a8
b7 :2 0 b9 69
bb 6b ba b9
:2 0 bc 6d :2 0
bf 27 :4 0 bf
be a5 bc :6 0
c0 1 0 90
94 bf 303 :2 0
26 :3 0 29 :a 0
f3 4 :7 0 28
:4 0 5 :3 0 c5
c6 0 f3 c3
c7 :2 0 4 :3 0
13 :2 0 6 :2 0
71 ca cc :3 0
cd :2 0 9 :3 0
cf d1 :2 0 d2
0 74 d3 ce
d2 0 d4 76
0 d8 28 :3 0
7 :3 0 d6 :2 0
d8 78 f2 1d
:3 0 1e :3 0 1f
:2 0 20 :2 0 7b
dc de :3 0 21
:4 0 22 :2 0 23
:3 0 24 :3 0 1c
:2 0 25 :2 0 7d
e2 e6 81 e1
e8 :3 0 84 db
ea :2 0 ec 87
ee 89 ed ec
:2 0 ef 8b :2 0
f2 29 :4 0 f2
f1 d8 ef :6 0
f3 1 0 c3
c7 f2 303 :2 0
26 :3 0 2a :a 0
1cb 5 400 :3 0
ff :2 0 8f :2 0
8d b :3 0 2b
:7 0 f9 f8 :3 0
28 :3 0 2c :3 0
2d :3 0 400 :4 0
fb fd 0 1cb
f6 100 :2 0 93
3e9 0 91 5
:3 0 103 :7 0 106
104 0 1c9 0
2e :6 0 1c :2 0
97 5 :3 0 108
:7 0 10b 109 0
1c9 0 2f :6 0
b :3 0 31 :2 0
95 10d 10f :6 0
112 110 0 1c9
0 30 :6 0 9d
43e 0 9b 33
:3 0 99 114 116
:6 0 119 117 0
1c9 0 32 :6 0
36 :2 0 9f 5
:3 0 11b :7 0 11e
11c 0 1c9 0
34 :6 0 5 :3 0
120 :7 0 123 121
0 1c9 0 35
:6 0 2b :3 0 a1
125 126 :3 0 127
:2 0 28 :6 0 12b
a3 12c 128 12b
0 12d a5 0
1b0 2e :3 0 37
:3 0 2b :3 0 a7
12f 131 12e 132
0 1b0 38 :3 0
38 :2 0 39 :3 0
135 0 136 0
a9 34 :3 0 3a
:3 0 ab 13b :2 0
13d :4 0 13f 140
:5 0 138 13c 0
ad 0 13e :2 0
1b0 3b :3 0 1c
:2 0 2e :3 0 3c
:3 0 143 144 :2 0
142 146 3d :3 0
3b :3 0 3e :2 0
34 :3 0 3f :2 0
1c :2 0 af 14c
14e :3 0 14f :2 0
b4 14a 151 :4 0
152 :3 0 1ad 32
:3 0 23 :3 0 2b
:3 0 3b :3 0 1c
:2 0 b7 155 159
154 15a 0 1ad
32 :3 0 13 :2 0
6 :4 0 bd 15d
15f :3 0 160 :3 0
163 c0 1aa 39
:3 0 40 :3 0 c2
2f :3 0 30 :3 0
3a :3 0 c5 16a
174 0 175 :3 0
39 :3 0 3b :3 0
13 :2 0 1f :2 0
1c :2 0 c7 16f
171 :3 0 cc 16e
173 :4 0 177 178
:5 0 166 16b 0
cf 0 176 :2 0
19f 14 :3 0 17c
:3 0 14 :2 0 d2
35 :3 0 41 :3 0
d4 180 186 0
187 :3 0 42 :3 0
30 :3 0 13 :2 0
d8 184 185 :4 0
189 18a :5 0 17d
181 0 db 0
188 :2 0 19f 35
:3 0 3e :2 0 6
:2 0 df 18d 18f
:3 0 190 :3 0 193
e2 19c 43 :3 0
44 :3 0 45 :3 0
30 :3 0 e4 196
198 199 :2 0 19b
e6 19d 191 193
0 19e 0 19b
0 19e e8 0
19f eb 1a7 46
:4 0 1a2 ef 1a4
f1 1a3 1a2 :2 0
1a5 f3 :2 0 1a7
0 1a7 1a6 19f
1a5 :6 0 1a9 6
:3 0 f5 1ab 161
163 0 1ac 0
1a9 0 1ac f7
0 1ad fa 1af
3c :3 0 147 1ad
:4 0 1b0 fe 1ca
1d :3 0 1e :3 0
1f :2 0 20 :2 0
103 1b4 1b6 :3 0
47 :4 0 22 :2 0
23 :3 0 24 :3 0
1c :2 0 25 :2 0
105 1ba 1be 109
1b9 1c0 :3 0 10c
1b3 1c2 :2 0 1c4
10f 1c6 111 1c5
1c4 :2 0 1c7 113
:2 0 1ca 2a :3 0
115 1ca 1c9 1b0
1c7 :6 0 1cb 1
0 f6 100 1ca
303 :2 0 26 :3 0
48 :a 0 2a3 8
400 :3 0 1d7 :2 0
11e :2 0 11c b
:3 0 2b :7 0 1d1
1d0 :3 0 28 :3 0
2c :3 0 2d :3 0
400 :4 0 1d3 1d5
0 2a3 1ce 1d8
:2 0 122 709 0
120 5 :3 0 1db
:7 0 1de 1dc 0
2a1 0 2e :6 0
1c :2 0 126 5
:3 0 1e0 :7 0 1e3
1e1 0 2a1 0
49 :6 0 b :3 0
31 :2 0 124 1e5
1e7 :6 0 1ea 1e8
0 2a1 0 4a
:6 0 12c 75e 0
12a 33 :3 0 128
1ec 1ee :6 0 1f1
1ef 0 2a1 0
32 :6 0 36 :2 0
12e 5 :3 0 1f3
:7 0 1f6 1f4 0
2a1 0 4b :6 0
5 :3 0 1f8 :7 0
1fb 1f9 0 2a1
0 35 :6 0 2b
:3 0 130 1fd 1fe
:3 0 1ff :2 0 28
:6 0 203 132 204
200 203 0 205
134 0 288 2e
:3 0 37 :3 0 2b
:3 0 136 207 209
206 20a 0 288
38 :3 0 38 :2 0
4c :3 0 20d 0
20e 0 138 4b
:3 0 4d :3 0 13a
213 :2 0 215 :4 0
217 218 :5 0 210
214 0 13c 0
216 :2 0 288 3b
:3 0 1c :2 0 2e
:3 0 3c :3 0 21b
21c :2 0 21a 21e
3d :3 0 3b :3 0
3e :2 0 4b :3 0
3f :2 0 1c :2 0
13e 224 226 :3 0
227 :2 0 143 222
229 :4 0 22a :3 0
285 32 :3 0 23
:3 0 2b :3 0 3b
:3 0 1c :2 0 146
22d 231 22c 232
0 285 32 :3 0
13 :2 0 6 :4 0
14c 235 237 :3 0
238 :3 0 23b 14f
282 4c :3 0 4e
:3 0 151 49 :3 0
4a :3 0 4d :3 0
154 242 24c 0
24d :3 0 4c :3 0
3b :3 0 13 :2 0
1f :2 0 1c :2 0
156 247 249 :3 0
15b 246 24b :4 0
24f 250 :5 0 23e
243 0 15e 0
24e :2 0 277 14
:3 0 254 :3 0 14
:2 0 161 35 :3 0
4f :3 0 163 258
25e 0 25f :3 0
50 :3 0 4a :3 0
13 :2 0 167 25c
25d :4 0 261 262
:5 0 255 259 0
16a 0 260 :2 0
277 35 :3 0 3e
:2 0 6 :2 0 16e
265 267 :3 0 268
:3 0 26b 171 274
43 :3 0 44 :3 0
45 :3 0 4a :3 0
173 26e 270 271
:2 0 273 175 275
269 26b 0 276
0 273 0 276
177 0 277 17a
27f 46 :4 0 27a
17e 27c 180 27b
27a :2 0 27d 182
:2 0 27f 0 27f
27e 277 27d :6 0
281 9 :3 0 184
283 239 23b 0
284 0 281 0
284 186 0 285
189 287 3c :3 0
21f 285 :4 0 288
18d 2a2 1d :3 0
1e :3 0 1f :2 0
51 :2 0 192 28c
28e :3 0 47 :4 0
22 :2 0 23 :3 0
24 :3 0 1c :2 0
25 :2 0 194 292
296 198 291 298
:3 0 19b 28b 29a
:2 0 29c 19e 29e
1a0 29d 29c :2 0
29f 1a2 :2 0 2a2
48 :3 0 1a4 2a2
2a1 288 29f :6 0
2a3 1 0 1ce
1d8 2a2 303 :2 0
52 :a 0 2fc b
:7 0 1ad 9f0 0
1ab 5 :3 0 53
:7 0 2a8 2a7 :3 0
56 :2 0 1af b
:3 0 54 :7 0 2ac
2ab :3 0 2ae :2 0
2fc 2a5 2af :2 0
13 :2 0 1b4 b
:3 0 1b2 2b2 2b4
:6 0 2b7 2b5 0
2fa 0 55 :6 0
53 :3 0 6 :2 0
1b8 2b9 2bb :3 0
2bc :2 0 55 :3 0
57 :4 0 22 :2 0
54 :3 0 1bb 2c0
2c2 :3 0 2be 2c3
0 2c5 1be 2ce
55 :3 0 58 :4 0
22 :2 0 54 :3 0
1c0 2c8 2ca :3 0
2c6 2cb 0 2cd
1c3 2cf 2bd 2c5
0 2d0 0 2cd
0 2d0 1c5 0
2d6 59 :3 0 5a
:3 0 55 :3 0 2d3
:4 0 2d4 :2 0 2d6
1c8 2fb 1d :3 0
5b :3 0 5c :2 0
1f :2 0 5d :2 0
1cb 2db 2dd :3 0
1cf 2da 2df :3 0
1e :3 0 1f :2 0
5e :2 0 1d2 2e2
2e4 :3 0 47 :4 0
22 :2 0 23 :3 0
24 :3 0 1c :2 0
25 :2 0 1d4 2e8
2ec 1d8 2e7 2ee
:3 0 1db 2e1 2f0
:2 0 2f2 1de 2f3
2e0 2f2 0 2f4
1e0 0 2f5 1e2
2f7 1e4 2f6 2f5
:2 0 2f8 1e6 :2 0
2fb 52 :3 0 1e8
2fb 2fa 2d6 2f8
:6 0 2fc 1 0
2a5 2af 2fb 303
:3 0 301 0 301
:3 0 301 303 2ff
300 :6 0 304 :2 0
3 :3 0 1ea 0
3 301 307 :3 0
306 304 308 :8 0

1f4
4
:3 0 1 4 1
a 1 10 1
1c 1 1a 1
21 1 24 1
23 1 2c 1
2f 1 33 1
38 1 3a 2
35 3a 1 2e
1 43 2 49
4c 1 52 2
51 52 1 5c
2 58 5c 1
65 2 63 65
1 46 4 2b
41 6e 71 1
77 3 7d 7e
7f 2 7a 81
2 79 83 1
85 1 74 1
88 1 1f 1
98 2 96 98
1 9d 1 a0
2 a1 a4 1
aa 3 b0 b1
b2 2 ad b4
2 ac b6 1
b8 1 a7 1
bb 1 cb 2
c9 cb 1 d0
1 d3 2 d4
d7 1 dd 3
e3 e4 e5 2
e0 e7 2 df
e9 1 eb 1
da 1 ee 1
f7 1 fa 1
102 1 107 1
10e 1 10c 1
115 1 113 1
11a 1 11f 1
124 1 12a 1
12c 1 130 1
137 1 13a 1
139 2 14b 14d
1 150 2 149
150 3 156 157
158 1 15e 2
15c 15e 1 162
2 164 165 1
169 2 16d 170
1 172 2 16c
172 2 167 168
1 17b 1 17f
1 183 2 182
183 1 17e 1
18e 2 18c 18e
1 192 1 197
1 19a 2 19c
19d 3 179 18b
19e 1 1a1 1
1a0 1 1a4 1
1a7 2 1aa 1ab
3 153 15b 1ac
4 12d 133 141
1af 1 1b5 3
1bb 1bc 1bd 2
1b8 1bf 2 1b7
1c1 1 1c3 1
1b2 1 1c6 6
105 10a 111 118
11d 122 1 1cf
1 1d2 1 1da
1 1df 1 1e6
1 1e4 1 1ed
1 1eb 1 1f2
1 1f7 1 1fc
1 202 1 204
1 208 1 20f
1 212 1 211
2 223 225 1
228 2 221 228
3 22e 22f 230
1 236 2 234
236 1 23a 2
23c 23d 1 241
2 245 248 1
24a 2 244 24a
2 23f 240 1
253 1 257 1
25b 2 25a 25b
1 256 1 266
2 264 266 1
26a 1 26f 1
272 2 274 275
3 251 263 276
1 279 1 278
1 27c 1 27f
2 282 283 3
22b 233 284 4
205 20b 219 287
1 28d 3 293
294 295 2 290
297 2 28f 299
1 29b 1 28a
1 29e 6 1dd
1e2 1e9 1f0 1f5
1fa 1 2a6 1
2aa 2 2a9 2ad
1 2b3 1 2b1
1 2ba 2 2b8
2ba 2 2bf 2c1
1 2c4 2 2c7
2c9 1 2cc 2
2ce 2cf 2 2d0
2d5 1 2dc 1
2de 2 2d9 2de
1 2e3 3 2e9
2ea 2eb 2 2e6
2ed 2 2e5 2ef
1 2f1 1 2f3
1 2f4 1 2d8
1 2f7 1 2b6
9 8 e 14
8d c0 f3 1cb
2a3 2fc 
1
4
0 
307
0
1
14
b
1e
0 1 1 1 1 5 6 1
8 9 1 0 0 0 0 0
0 0 0 0 
1f7 8 0
11f 5 0
10c 5 0
2a5 1 b
1cf 8 0
f7 5 0
2aa b 0
16 1 2
1e4 8 0
1da 8 0
102 5 0
1ce 1 8
2b1 b 0
107 5 0
4 1 0
1eb 8 0
113 5 0
10 1 0
3 0 1
11a 5 0
2a6 b 0
1a 2 0
1df 8 0
21a 9 0
142 6 0
1f2 8 0
a 1 0
c3 1 4
f6 1 5
90 1 3
0

/
create or replace view FCO_READ_LOOKUP_V
(fcoId
) 
as ( select distinct 
l.fcoId
from FCO_READ_LOOKUP l
where l.privilegeOwnerId =  SECURITY_PV_UTILITIES.CUR_USERID or
l.PRIVILEGEOWNERID in(select wbrole from CMPRoleAssignment_V where wbuser= SECURITY_PV_UTILITIES.CUR_USERID) 
UNION ALL
select distinct 
elementid 
from cmpprivilegeowner_v 
where SECURITY_PV_UTILITIES.IS_CUR_USER_ADMIN =1
);