create or replace procedure start_access_publicview wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
7
9200000
1
4
0 
2b
2 :e:
1START_ACCESS_PUBLICVIEW:
1OTHERROLES:
1VARCHAR2:
1AUTHID:
1CURRENT_USER:
1CLEARTEXT:
12000:
1GRANTEDROLE:
130:
1CUR_USER:
1RAWKEY:
1RAW:
11028:
1ALTER_COMMAND:
1300:
1GRANTED_ROLE:
1USER_ROLE_PRIVS:
1=:
1OWB_DESIGNCENTER_VIEW:
1NO_DATA_FOUND:
1RAISE_APPLICATION_ERROR:
1-:
120000:
1You are not a registered user on workspace:::
1||:
1SYS_CONTEXT:
1owb_workspace:
1workspaceName:
1,and you can not access the public views of the workspace.:
1hasPublicViewPriv:
10:
1isWorkspaceAdmin:
120001:
1You have no right to access public view or design center browser on workspace+
1:::
1IS NULL:
1SET ROLE OWB_USER, OWB_DESIGNCENTER_VIEW:
1SET ROLE OWB_USER,:
1 OWB_DESIGNCENTER_VIEW:
1EXECUTE:
1IMMEDIATE:
1DBMS_OUTPUT:
1PUT_LINE:
1Start Access Public View successfully.:
0

0
0
b0
2
0 9a 8f a0 4d b0 3d b4
:2 a0 55 6a a3 a0 51 a5 1c
81 b0 a3 a0 51 a5 1c 81
b0 a3 a0 51 a5 1c 81 b0
a3 a0 51 a5 1c 81 b0 a3
a0 51 a5 1c 81 b0 a0 ac
:2 a0 b2 ee a0 7e 6e b4 2e
ac e5 d0 b2 e9 b7 :2 a0 7e
51 b4 2e 6e 7e a0 :2 6e a5
b b4 2e 7e 6e b4 2e a5
57 b7 a6 9 a4 b1 11 4f
a0 :2 6e a5 b 7e 51 b4 2e
a0 :2 6e a5 b 7e 51 b4 2e
a 10 5a a0 7e 51 b4 2e
6e 7e a0 :2 6e a5 b b4 2e
a5 57 b7 19 3c a0 7e b4
2e 5a a0 6e d b7 a0 6e
7e a0 b4 2e 7e 6e b4 2e
d b7 :2 19 3c :3 a0 11e 11d :2 a0
6b 6e a5 57 b7 a4 b1 11
68 4f 1d 17 b5 
b0
2
0 3 20 1b 1f 1a 28 17
2d 31 35 39 56 41 45 48
49 51 40 73 61 3d 65 66
6e 60 90 7e 5d 82 83 8b
7d ad 9b 7a 9f a0 a8 9a
ca b8 97 bc bd c5 b7 d1
b4 d5 d9 dd de e5 e9 ec
f1 f2 f7 f8 fe 102 103 108
10a 10e 112 115 118 119 11e 123
126 12a 12f 134 135 137 138 13d
140 145 146 14b 14c 151 153 154
159 15d 15f 16b 16d 171 176 17b
17c 17e 181 184 185 18a 18e 193
198 199 19b 19e 1a1 1a2 1 1a7
1ac 1af 1b3 1b6 1b9 1ba 1bf 1c4
1c7 1cb 1d0 1d5 1d6 1d8 1d9 1de
1df 1e4 1e6 1ea 1ed 1f1 1f4 1f5
1fa 1fd 201 206 20a 20c 210 215
218 21c 21d 222 225 22a 22b 230
234 236 23a 23e 241 245 249 24d
252 256 25a 25e 261 266 267 26c
26e 272 274 280 284 286 287 290 
b0
2
0 b 23 31 42 :2 23 22 1
8 :2 1 2 c 15 14 :2 c :2 2
e 17 16 :2 e :2 2 b 14 13
:2 b :2 2 9 d c :2 9 :2 2 10
19 18 :2 10 2 :2 b 1d 2e 29
2e 44 50 51 :2 50 29 :4 4 2
13 f 27 28 :2 27 2e 5b 5d
69 79 :2 5d :2 2e 89 8b :2 2e :2 f
21 :2 d 9 :3 1 b 17 27 :2 b
3b 3c :2 3b 4 10 20 :2 4 33
34 :2 33 :2 b a 2 1a 1b :2 1a
21 71 73 7f 8f :2 73 :2 21 :2 2
38 :2 8 :4 5 4 2 13 2 19
5 16 2a 2d :2 16 38 3a :2 16
5 :4 2 9 11 1b :3 9 :2 15 1e
:2 9 :9 1 
b0
4
0 :7 1 :2 2 :2 1
:7 6 :7 7 :7 8 :7 9
:7 a :10 12 11 15
:14 17 :3 15 13 :3 c
:9 1b :9 1c :3 1b :10 1d
1c :2 1b :5 25 :3 27
25 :b 2b 29 :3 25
:5 2e :6 31 :2 c :7 1

292
4
:3 0 1 :a 0 ab
1 :7 0 5 :2 0
:2 3 :4 0 2 :7 0
5 3 4 :2 0
4 :3 0 5 :3 0
7 :2 0 ab 1
a :2 0 9 :2 0
9 3 :3 0 7
:2 0 7 d f
:6 0 12 10 0
a9 0 6 :6 0
9 :2 0 d 3
:3 0 b 14 16
:6 0 19 17 0
a9 0 8 :6 0
d :2 0 11 3
:3 0 f 1b 1d
:6 0 20 1e 0
a9 0 a :6 0
f :2 0 15 c
:3 0 13 22 24
:6 0 27 25 0
a9 0 b :6 0
1b :2 0 19 3
:3 0 17 29 2b
:6 0 2e 2c 0
a9 0 e :6 0
10 :3 0 8 :3 0
11 :3 0 1d 33
39 0 3a :3 0
10 :3 0 12 :2 0
13 :4 0 21 36
38 :4 0 3c 3d
:5 0 30 34 0
24 0 3b :2 0
3f 26 5a 14
:3 0 15 :3 0 16
:2 0 17 :2 0 28
42 44 :3 0 18
:4 0 19 :2 0 1a
:3 0 1b :4 0 1c
:4 0 2a 48 4b
2d 47 4d :3 0
19 :2 0 1d :4 0
30 4f 51 :3 0
33 41 53 :2 0
55 36 57 38
56 55 :2 0 58
3a :2 0 5a 0
5a 59 3f 58
:6 0 a7 1 :3 0
1a :3 0 1b :4 0
1e :4 0 3c 5c
5f 12 :2 0 1f
:2 0 41 61 63
:3 0 1a :3 0 1b
:4 0 20 :4 0 44
65 68 12 :2 0
1f :2 0 49 6a
6c :3 0 64 6e
6d :2 0 6f :2 0
15 :3 0 16 :2 0
21 :2 0 4c 72
74 :3 0 22 :4 0
19 :2 0 1a :3 0
1b :4 0 1c :4 0
4e 78 7b 51
77 7d :3 0 54
71 7f :2 0 81
57 82 70 81
0 83 59 0
a7 2 :3 0 23
:2 0 5b 85 86
:3 0 87 :2 0 e
:3 0 24 :4 0 89
8a 0 8c 5d
99 e :3 0 25
:4 0 19 :2 0 2
:3 0 5f 8f 91
:3 0 19 :2 0 26
:4 0 62 93 95
:3 0 8d 96 0
98 65 9a 88
8c 0 9b 0
98 0 9b 67
0 a7 27 :3 0
28 :3 0 e :3 0
9e :4 0 9f :2 0
a7 29 :3 0 2a
:3 0 a1 a2 0
2b :4 0 6a a3
a5 :2 0 a7 6c
aa :3 0 aa 72
aa a9 a7 a8
:6 0 ab :2 0 1
a aa ae :3 0
ad ab af :4 0
5 :3 0 
78
4
:3 0 1 2 1
6 1 e 1
c 1 15 1
13 1 1c 1
1a 1 23 1
21 1 2a 1
28 1 2f 1
32 1 37 2
35 37 1 31
1 3e 1 43
2 49 4a 2
46 4c 2 4e
50 2 45 52
1 54 1 40
1 57 2 5d
5e 1 62 2
60 62 2 66
67 1 6b 2
69 6b 1 73
2 79 7a 2
76 7c 2 75
7e 1 80 1
82 1 84 1
8b 2 8e 90
2 92 94 1
97 2 99 9a
1 a4 5 5a
83 9b a0 a6
5 11 18 1f
26 2d 
1
4
0 
ae
0
1
14
2
7
0 1 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
28 1 0
1 0 1
13 1 0
2 1 0
21 1 0
1a 1 0
c 1 0
0

/
/*
 if user has access public view priv, this proceure will enable OWB_USER+otherRoles+owb_designcenter_view role
 otherwise this procedure will only enable : 	 OWB_USER+otherRoles
NOTE: otherRole should be format: 'role1,role2,', notice the last comma is needed
*/
create or replace procedure start_enable_owb_roles wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
7
9200000
1
4
0 
2c
2 :e:
1START_ENABLE_OWB_ROLES:
1OTHERROLES:
1VARCHAR2:
1AUTHID:
1CURRENT_USER:
1CLEARTEXT:
12000:
1GRANTEDROLE:
130:
1CUR_USER:
1RAWKEY:
1RAW:
11028:
1ALTER_COMMAND:
1300:
1GRANTED_ROLE:
1USER_ROLE_PRIVS:
1=:
1OWB_DESIGNCENTER_VIEW:
1NO_DATA_FOUND:
1RAISE_APPLICATION_ERROR:
1-:
120000:
1You are not a registered user on workspace:::
1||:
1SYS_CONTEXT:
1owb_workspace:
1workspaceName:
1,and you can not access the public views of the workspace.:
1hasPublicViewPriv:
11:
1isWorkspaceAdmin:
1IS NULL:
1SET ROLE OWB_USER, OWB_DESIGNCENTER_VIEW:
1SET ROLE OWB_USER,:
1 OWB_DESIGNCENTER_VIEW:
1SET ROLE OWB_USER:
1SET ROLE :
1OWB_USER:
1EXECUTE:
1IMMEDIATE:
1DBMS_OUTPUT:
1PUT_LINE:
1Start OWB Roles successfully.:
0

0
0
ba
2
0 9a 8f a0 4d b0 3d b4
:2 a0 55 6a a3 a0 51 a5 1c
81 b0 a3 a0 51 a5 1c 81
b0 a3 a0 51 a5 1c 81 b0
a3 a0 51 a5 1c 81 b0 a3
a0 51 a5 1c 81 b0 a0 ac
:2 a0 b2 ee a0 7e 6e b4 2e
ac e5 d0 b2 e9 b7 :2 a0 7e
51 b4 2e 6e 7e a0 :2 6e a5
b b4 2e 7e 6e b4 2e a5
57 b7 a6 9 a4 b1 11 4f
a0 :2 6e a5 b 7e 51 b4 2e
a0 :2 6e a5 b 7e 51 b4 2e
52 10 5a a0 7e b4 2e 5a
a0 6e d b7 a0 6e 7e a0
b4 2e 7e 6e b4 2e d b7
:2 19 3c b7 a0 7e b4 2e 5a
a0 6e d b7 a0 6e 7e a0
b4 2e 7e 6e b4 2e d b7
:2 19 3c b7 :2 19 3c :3 a0 11e 11d
:2 a0 6b 6e a5 57 b7 a4 b1
11 68 4f 1d 17 b5 
ba
2
0 3 20 1b 1f 1a 28 17
2d 31 35 39 56 41 45 48
49 51 40 73 61 3d 65 66
6e 60 90 7e 5d 82 83 8b
7d ad 9b 7a 9f a0 a8 9a
ca b8 97 bc bd c5 b7 d1
b4 d5 d9 dd de e5 e9 ec
f1 f2 f7 f8 fe 102 103 108
10a 10e 112 115 118 119 11e 123
126 12a 12f 134 135 137 138 13d
140 145 146 14b 14c 151 153 154
159 15d 15f 16b 16d 171 176 17b
17c 17e 181 184 185 18a 18e 193
198 199 19b 19e 1a1 1a2 1 1a7
1ac 1af 1b3 1b6 1b7 1bc 1bf 1c3
1c8 1cc 1ce 1d2 1d7 1da 1de 1df
1e4 1e7 1ec 1ed 1f2 1f6 1f8 1fc
200 203 205 209 20c 20d 212 215
219 21e 222 224 228 22d 230 234
235 23a 23d 242 243 248 24c 24e
252 256 259 25b 25f 263 266 26a
26e 272 277 27b 27f 283 286 28b
28c 291 293 297 299 2a5 2a9 2ab
2ac 2b5 
ba
2
0 b 22 30 41 :2 22 21 1
8 :2 1 2 c 15 14 :2 c :2 2
e 17 16 :2 e :2 2 b 14 13
:2 b :2 2 9 d c :2 9 :2 2 10
19 18 :2 10 2 :2 b 1d 2e 29
2e 44 50 51 :2 50 29 :4 4 2
13 10 28 29 :2 28 2f 5c 5e
6a 7a :2 5e :2 2f 8a 8c :2 2f :2 10
21 :2 d 9 :3 1 b 17 27 :2 b
3b 3c :2 3b a 16 26 :2 a 39
3a :2 39 :2 b a :4 6 5 4 15
4 1a 6 17 2b 2e :2 17 39
3b :2 17 6 :4 3 3e :4 6 5 b
1c b 1a d 1e 29 2b :2 1e
35 37 :2 1e d :4 3 2 :3 8 9
11 1b :3 9 :2 15 1e :2 9 :9 1 
ba
4
0 :7 1 :2 2 :2 1
:7 6 :7 7 :7 8 :7 9
:7 a :10 12 11 15
:14 17 :3 15 13 :3 c
:9 1b :9 1c :3 1b :5 1f
:3 21 1f :b 26 24
:3 1f 1c :5 2b :3 2d
2b :b 31 2f :3 2b
29 :3 1b :5 37 :6 3a
:2 c :7 1 
2b7
4
:3 0 1 :a 0 b5
1 :7 0 5 :2 0
:2 3 :4 0 2 :7 0
5 3 4 :2 0
4 :3 0 5 :3 0
7 :2 0 b5 1
a :2 0 9 :2 0
9 3 :3 0 7
:2 0 7 d f
:6 0 12 10 0
b3 0 6 :6 0
9 :2 0 d 3
:3 0 b 14 16
:6 0 19 17 0
b3 0 8 :6 0
d :2 0 11 3
:3 0 f 1b 1d
:6 0 20 1e 0
b3 0 a :6 0
f :2 0 15 c
:3 0 13 22 24
:6 0 27 25 0
b3 0 b :6 0
1b :2 0 19 3
:3 0 17 29 2b
:6 0 2e 2c 0
b3 0 e :6 0
10 :3 0 8 :3 0
11 :3 0 1d 33
39 0 3a :3 0
10 :3 0 12 :2 0
13 :4 0 21 36
38 :4 0 3c 3d
:5 0 30 34 0
24 0 3b :2 0
3f 26 5a 14
:3 0 15 :3 0 16
:2 0 17 :2 0 28
42 44 :3 0 18
:4 0 19 :2 0 1a
:3 0 1b :4 0 1c
:4 0 2a 48 4b
2d 47 4d :3 0
19 :2 0 1d :4 0
30 4f 51 :3 0
33 41 53 :2 0
55 36 57 38
56 55 :2 0 58
3a :2 0 5a 0
5a 59 3f 58
:6 0 b1 1 :3 0
1a :3 0 1b :4 0
1e :4 0 3c 5c
5f 12 :2 0 1f
:2 0 41 61 63
:3 0 1a :3 0 1b
:4 0 20 :4 0 44
65 68 12 :2 0
1f :2 0 49 6a
6c :3 0 64 6e
6d :2 0 6f :2 0
2 :3 0 21 :2 0
4c 72 73 :3 0
74 :2 0 e :3 0
22 :4 0 76 77
0 79 4e 86
e :3 0 23 :4 0
19 :2 0 2 :3 0
50 7c 7e :3 0
19 :2 0 24 :4 0
53 80 82 :3 0
7a 83 0 85
56 87 75 79
0 88 0 85
0 88 58 0
89 5b a3 2
:3 0 21 :2 0 5d
8b 8c :3 0 8d
:2 0 e :3 0 25
:4 0 8f 90 0
92 5f 9f e
:3 0 26 :4 0 19
:2 0 2 :3 0 61
95 97 :3 0 19
:2 0 27 :4 0 64
99 9b :3 0 93
9c 0 9e 67
a0 8e 92 0
a1 0 9e 0
a1 69 0 a2
6c a4 70 89
0 a5 0 a2
0 a5 6e 0
b1 28 :3 0 29
:3 0 e :3 0 a8
:4 0 a9 :2 0 b1
2a :3 0 2b :3 0
ab ac 0 2c
:4 0 71 ad af
:2 0 b1 73 b4
:3 0 b4 78 b4
b3 b1 b2 :6 0
b5 :2 0 1 a
b4 b8 :3 0 b7
b5 b9 :4 0 5
:3 0 
7e
4
:3 0 1 2 1
6 1 e 1
c 1 15 1
13 1 1c 1
1a 1 23 1
21 1 2a 1
28 1 2f 1
32 1 37 2
35 37 1 31
1 3e 1 43
2 49 4a 2
46 4c 2 4e
50 2 45 52
1 54 1 40
1 57 2 5d
5e 1 62 2
60 62 2 66
67 1 6b 2
69 6b 1 71
1 78 2 7b
7d 2 7f 81
1 84 2 86
87 1 88 1
8a 1 91 2
94 96 2 98
9a 1 9d 2
9f a0 1 a1
2 a3 a4 1
ae 4 5a a5
aa b0 5 11
18 1f 26 2d

1
4
0 
b8
0
1
14
2
7
0 1 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
28 1 0
13 1 0
2 1 0
21 1 0
1a 1 0
1 0 1
c 1 0
0

/
create or replace function getRoleStarted wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
8
9200000
1
4
0 
1c
2 :e:
1FUNCTION:
1GETROLESTARTED:
1THESTR:
1VARCHAR2:
1RETURN:
1RAW:
1RAWKEY:
11028:
1ENCRYPTED_RAW:
12000:
1L_TYP:
1PLS_INTEGER:
1SYS:
1DBMS_CRYPTO:
1ENCRYPT_DES:
1+:
1CHAIN_CBC:
1PAD_PKCS5:
1L_RAW_VALUE:
1WBSECURITYHELPER:
1DIGESTSCHEMA:
1UPPER:
1FALSE:
1OWB_USER_ROLE_ENABLING_PWD:
1OWB_ROLE_INFO:
1DECRYPT:
1OTHERS:
1RAISE:
0

0
0
71
2
0 a0 8d 8f a0 b0 3d b4
:2 a0 2c 6a a3 a0 51 a5 1c
81 b0 a3 a0 51 a5 1c 81
b0 a3 a0 1c :2 a0 6b a0 6b
7e :2 a0 6b a0 6b b4 2e 7e
:2 a0 6b a0 6b b4 2e 81 b0
a3 a0 51 a5 1c 81 b0 :3 a0
6b :2 a0 a5 b a0 a5 b d
a0 ac :2 a0 b2 ee ac e5 d0
b2 e9 :3 a0 6b a0 6b :3 a0 a5
b d :2 a0 65 b7 a0 53 a0
62 b7 a6 9 a4 b1 11 68
4f 1d 17 b5 
71
2
0 3 7 23 1f 1e 2b 1b
30 34 38 3c 59 44 48 4b
4c 54 43 76 64 40 68 69
71 63 d7 81 85 8d 91 60
95 99 9c 9f a3 a7 aa ae
b1 b2 b7 ba be c2 c5 c9
cc cd d2 80 f4 e2 7d e6
e7 ef e1 fb ff 103 de 107
10b 10f 110 112 116 117 119 11d
121 122 126 12a 12b 132 133 139
13d 13e 143 147 14b 14f 152 156
159 15d 161 165 166 168 16c 170
174 178 17a 1 17e 182 185 187
188 18d 191 193 19f 1a3 1a5 1a6
1af 
71
2
0 1 a 19 20 :2 19 18 2a
31 :2 1 2 9 d c :2 9 :2 2
10 14 13 :2 10 :2 2 :2 8 17 :2 1b
:2 27 33 35 :2 39 :2 45 :2 17 4f 51
:2 55 :2 61 :2 17 8 :2 2 e 12 11
:2 e :2 2 b :2 1c 29 2f :2 29 38
:2 b 2 :2 10 30 43 3e 43 3e
:4 9 2 11 :2 15 :2 21 1f 20 1f
:2 11 :2 2 9 2 1 :2 7 :2 2 e
:2 2 :8 1 
71
4
0 :b 1 :7 5 :7 6
:1a 7 :7 8 :c c :b d
:6 e f 10 11
:3 e :3 13 b :2 16
:2 18 :3 16 15 :7 1

1b1
4
:3 0 1 :3 0 2
:a 0 6c 1 :7 0
5 :2 0 3 4
:3 0 3 :7 0 5
4 :3 0 5 :3 0
6 :3 0 7 9
0 6c 2 a
:2 0 a :2 0 9
6 :3 0 8 :2 0
7 d f :6 0
12 10 0 6a
0 7 :6 0 1d
1e 0 d 6
:3 0 b 14 16
:6 0 19 17 0
6a 0 9 :6 0
8 :2 0 15 c
:3 0 1b :7 0 d
:3 0 e :3 0 f
:3 0 1f 20 0
10 :2 0 d :3 0
e :3 0 23 24
0 11 :3 0 25
26 0 f 22
28 :3 0 10 :2 0
d :3 0 e :3 0
2b 2c 0 12
:3 0 2d 2e 0
12 2a 30 :3 0
33 1c 31 6a
0 b :6 0 3c
3d 0 19 6
:3 0 17 35 37
:6 0 3a 38 0
6a 0 13 :6 0
7 :3 0 14 :3 0
15 :3 0 16 :3 0
3 :3 0 1b 3f
41 17 :3 0 1d
3e 44 3b 45
0 61 18 :3 0
20 9 :3 0 19
:3 0 22 4b :2 0
4d :4 0 4f 50
:5 0 48 4c 0
24 0 4e :2 0
61 13 :3 0 d
:3 0 e :3 0 53
54 0 1a :3 0
55 56 0 9
:3 0 b :3 0 7
:3 0 26 57 5b
52 5c 0 61
5 :3 0 13 :3 0
5f :2 0 61 2a
6b 1b :3 0 1c
:5 0 66 2f 68
31 67 66 :2 0
69 33 :2 0 6b
35 6b 6a 61
69 :6 0 6c :2 0
2 a 6b 6f
:3 0 6e 6c 70
:8 0 
3a
4
:3 0 1 3 1
6 1 e 1
c 1 15 1
13 2 21 27
2 29 2f 1
1a 1 36 1
34 1 40 2
42 43 1 47
1 4a 1 49
3 58 59 5a
4 46 51 5d
60 1 65 1
63 1 68 4
11 18 32 39

1
4
0 
6f
0
1
14
1
6
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
34 1 0
2 0 1
13 1 0
1a 1 0
3 1 0
c 1 0
0

/