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 /