Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\public_view_sec

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\public_view_sec_owbmeta.plb

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=:
1OWBM_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:
120001:
1You have no right to access public view or design center browser on workspace+
1:::
1GETSECTEXT:
1IS NULL:
1SET ROLE OWBM_USER, OWBM_DESIGNCENTER_VIEW  IDENTIFIED BY :
1SET ROLE OWBM_USER,:
1 OWBM_DESIGNCENTER_VIEW IDENTIFIED BY :
1EXECUTE:
1IMMEDIATE:
1DBMS_OUTPUT:
1PUT_LINE:
1Start Access Public View successfully.:
0

0
0
b2
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
5a a0 7e 51 b4 2e 6e 7e
a0 :2 6e a5 b b4 2e a5 57
b7 19 3c :2 a0 b4 2e d a0
7e b4 2e 5a a0 6e 7e a0
b4 2e d b7 a0 6e 7e a0
b4 2e 7e 6e b4 2e 7e a0
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 
b2
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 18d 191
194 197 198 19d 1a2 1a5 1a9 1ae
1b3 1b4 1b6 1b7 1bc 1bd 1c2 1c4
1c8 1cb 1cf 1d3 1d4 1d9 1dd 1e1
1e4 1e5 1ea 1ed 1f1 1f6 1f9 1fd
1fe 203 207 209 20d 212 215 219
21a 21f 222 227 228 22d 230 234
235 23a 23e 240 244 248 24b 24f
253 257 25c 260 264 268 26b 270
271 276 278 27c 27e 28a 28e 290
291 29a 
b2
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 a 2 1a 1b :2 1a
21 71 73 7f 8f :2 73 :2 21 :2 2
3f :2 8 2 :3 d 2 :4 5 4 2
13 4f 51 :2 13 2 19 5 16
2b 2e :2 16 39 3b :2 16 63 65
:2 16 5 :4 2 9 11 1b :3 9 :2 15
1e :2 9 :9 1 
b2
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
:a 1a :10 1b :3 1a :5 1e
:5 23 :7 25 23 :f 29
27 :3 23 :5 2c :6 2f
:2 c :7 1 
29c
4
:3 0 1 :a 0 ad
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 ad 1
a :2 0 9 :2 0
9 3 :3 0 7
:2 0 7 d f
:6 0 12 10 0
ab 0 6 :6 0
9 :2 0 d 3
:3 0 b 14 16
:6 0 19 17 0
ab 0 8 :6 0
d :2 0 11 3
:3 0 f 1b 1d
:6 0 20 1e 0
ab 0 a :6 0
f :2 0 15 c
:3 0 13 22 24
:6 0 27 25 0
ab 0 b :6 0
1b :2 0 19 3
:3 0 17 29 2b
:6 0 2e 2c 0
ab 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 a9 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 64 :2 0 15
:3 0 16 :2 0 20
:2 0 44 67 69
:3 0 21 :4 0 19
:2 0 1a :3 0 1b
:4 0 1c :4 0 46
6d 70 49 6c
72 :3 0 4c 66
74 :2 0 76 4f
77 65 76 0
78 51 0 a9
6 :3 0 22 :4 0
7a 7b :3 0 79
7c 0 a9 2
:3 0 23 :2 0 53
7f 80 :3 0 81
:2 0 e :3 0 24
:4 0 19 :2 0 6
:3 0 55 85 87
:3 0 83 88 0
8a 58 9b e
:3 0 25 :4 0 19
:2 0 2 :3 0 5a
8d 8f :3 0 19
:2 0 26 :4 0 5d
91 93 :3 0 19
:2 0 6 :3 0 60
95 97 :3 0 8b
98 0 9a 63
9c 82 8a 0
9d 0 9a 0
9d 65 0 a9
27 :3 0 28 :3 0
e :3 0 a0 :4 0
a1 :2 0 a9 29
:3 0 2a :3 0 a3
a4 0 2b :4 0
68 a5 a7 :2 0
a9 6a ac :3 0
ac 71 ac ab
a9 aa :6 0 ad
:2 0 1 a ac
b0 :3 0 af ad
b1 :4 0 5 :3 0

77
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 1 68
2 6e 6f 2
6b 71 2 6a
73 1 75 1
77 1 7e 2
84 86 1 89
2 8c 8e 2
90 92 2 94
96 1 99 2
9b 9c 1 a6
6 5a 78 7d
9d a2 a8 5
11 18 1f 26
2d 
1
4
0 
b0
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 OWBM_USER+otherRoles+owb_designcenter_view role
 otherwise this procedure will only enable : 	 OWBM_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=:
1OWBM_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:
1GETSECTEXT:
1IS NULL:
1SET ROLE OWBM_USER, OWBM_DESIGNCENTER_VIEW  IDENTIFIED BY :
1SET ROLE OWBM_USER,:
1 OWBM_DESIGNCENTER_VIEW IDENTIFIED BY :
1SET ROLE OWBM_USER:
1SET ROLE :
1OWBM_USER:
1EXECUTE:
1IMMEDIATE:
1DBMS_OUTPUT:
1PUT_LINE:
1Start OWB Roles successfully.:
0

0
0
bc
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
5a :2 a0 b4 2e d a0 7e b4
2e 5a a0 6e 7e a0 b4 2e
d b7 a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e a0 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 
bc
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 18d 191
195 196 19b 19f 1a3 1a6 1a7 1ac
1af 1b3 1b8 1bb 1bf 1c0 1c5 1c9
1cb 1cf 1d4 1d7 1db 1dc 1e1 1e4
1e9 1ea 1ef 1f2 1f6 1f7 1fc 200
202 206 20a 20d 20f 213 216 217
21c 21f 223 228 22c 22e 232 237
23a 23e 23f 244 247 24c 24d 252
256 258 25c 260 263 265 269 26d
270 274 278 27c 281 285 289 28d
290 295 296 29b 29d 2a1 2a3 2af
2b3 2b5 2b6 2bf 
bc
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 3 :3 e 3 :4 6
5 4 15 51 53 :2 15 4 1a
6 17 2c 2f :2 17 3a 3c :2 17
64 66 :2 17 6 :4 3 3f :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

bc
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
:a 1a :5 1b :5 1d :7 1f
1d :f 24 22 :3 1d
1a :5 29 :3 2b 29
:b 2f 2d :3 29 27
:3 1a :5 35 :6 38 :2 c
:7 1 
2c1
4
:3 0 1 :a 0 b7
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 b7 1
a :2 0 9 :2 0
9 3 :3 0 7
:2 0 7 d f
:6 0 12 10 0
b5 0 6 :6 0
9 :2 0 d 3
:3 0 b 14 16
:6 0 19 17 0
b5 0 8 :6 0
d :2 0 11 3
:3 0 f 1b 1d
:6 0 20 1e 0
b5 0 a :6 0
f :2 0 15 c
:3 0 13 22 24
:6 0 27 25 0
b5 0 b :6 0
1b :2 0 19 3
:3 0 17 29 2b
:6 0 2e 2c 0
b5 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 b3 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 64 :2 0 6
:3 0 20 :4 0 67
68 :3 0 66 69
0 8b 2 :3 0
21 :2 0 44 6c
6d :3 0 6e :2 0
e :3 0 22 :4 0
19 :2 0 6 :3 0
46 72 74 :3 0
70 75 0 77
49 88 e :3 0
23 :4 0 19 :2 0
2 :3 0 4b 7a
7c :3 0 19 :2 0
24 :4 0 4e 7e
80 :3 0 19 :2 0
6 :3 0 51 82
84 :3 0 78 85
0 87 54 89
6f 77 0 8a
0 87 0 8a
56 0 8b 59
a5 2 :3 0 21
:2 0 5c 8d 8e
:3 0 8f :2 0 e
:3 0 25 :4 0 91
92 0 94 5e
a1 e :3 0 26
:4 0 19 :2 0 2
:3 0 60 97 99
:3 0 19 :2 0 27
:4 0 63 9b 9d
:3 0 95 9e 0
a0 66 a2 90
94 0 a3 0
a0 0 a3 68
0 a4 6b a6
65 8b 0 a7
0 a4 0 a7
6d 0 b3 28
:3 0 29 :3 0 e
:3 0 aa :4 0 ab
:2 0 b3 2a :3 0
2b :3 0 ad ae
0 2c :4 0 70
af b1 :2 0 b3
72 b6 :3 0 b6
77 b6 b5 b3
b4 :6 0 b7 :2 0
1 a b6 ba
:3 0 b9 b7 bb
:4 0 5 :3 0 
7d
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 1 6b
2 71 73 1
76 2 79 7b
2 7d 7f 2
81 83 1 86
2 88 89 2
6a 8a 1 8c
1 93 2 96
98 2 9a 9c
1 9f 2 a1
a2 1 a3 2
a5 a6 1 b0
4 5a a7 ac
b2 5 11 18
1f 26 2d 
1
4
0 
ba
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

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de