Eric's Beijing Diary

create user PM31415926 identified by password;
create user PM36211124 identified by password;
create user PM37211101 identified by password;
create user PM37211102 identified by password;
create user PM37211103 identified by password;
create user PM37211104 identified by password;
create user AM37211401 identified by password;
create user AM37211402 identified by password;
create user AM37211404 identified by password;
create user AM37211405 identified by password;
create user AM37211406 identified by password;
create user AM37211407 identified by password;
create user AM37211408 identified by password;
create user AM37211409 identified by password;
create user AM37211410 identified by password;
create user AM37211411 identified by password;
create user AM37211412 identified by password;
create user AM37211413 identified by password;
create user AM37211414 identified by password;
create user AM37211415 identified by password;
create user AM37211416 identified by password;
create user AM37211417 identified by password;
create user AM37211418 identified by password;
create user AM37211419 identified by password;
create user AM37211420 identified by password;
create user AM37211421 identified by password;
create user AM37211422 identified by password;
create user AM37211425 identified by password;
create user AM37211426 identified by password;
create user AM37211427 identified by password;
create user AM37211501 identified by password;
create user AM37211502 identified by password;
create user AM37211503 identified by password;
create user AM37211504 identified by password;
create user AM37211505 identified by password;
create user AM37211506 identified by password;
create user AM37211507 identified by password;
create user AM37211508 identified by password;
create user AM37211509 identified by password;
create user AM37211510 identified by password;
create user AM37211511 identified by password;
create user AM37211512 identified by password;
create user AM37211513 identified by password;
create user AM37211514 identified by password;
create user AM37211515 identified by password;
create user AM37211516 identified by password;
create user AM37211517 identified by password;
create user AM37211518 identified by password;
create user AM37211519 identified by password;
create user AM37211520 identified by password;
create user AM37211521 identified by password;
create user AM37211522 identified by password;
create user AM37211523 identified by password;
create user AM37211524 identified by password;
create user AM37211525 identified by password;
create user AM37211526 identified by password;
create user AM37211527 identified by password;
create user AM37211530 identified by password;
create user AM56000248 identified by password;
create user AM56000255 identified by password;
create user PM37211222 identified by password;
create user AM36211320 identified by password;
create user AM37211423 identified by password;
create user PM37211119 identified by password;
create user PM37211325 identified by password;
create user AM35211119 identified by password;
create user PM35211215 identified by password;
create user PM36211508 identified by password;
create user PM37211105 identified by password;
create user PM37211106 identified by password;
create user PM37211107 identified by password;
create user PM37211108 identified by password;
create user PM37211109 identified by password;
create user PM37211110 identified by password;
create user PM37211111 identified by password;
create user PM37211112 identified by password;
create user PM37211113 identified by password;
create user PM37211114 identified by password;
create user PM37211115 identified by password;
create user PM37211116 identified by password;
create user PM37211117 identified by password;
create user PM37211118 identified by password;
create user PM37211120 identified by password;
create user PM37211121 identified by password;
create user PM37211122 identified by password;
create user PM37211123 identified by password;
create user PM37211124 identified by password;
create user PM37211125 identified by password;
create user PM37211126 identified by password;
create user PM37211127 identified by password;
create user PM37211128 identified by password;
create user PM37211201 identified by password;
create user PM37211202 identified by password;
create user PM37211203 identified by password;
create user PM37211204 identified by password;
create user PM37211205 identified by password;
create user PM37211206 identified by password;
create user PM37211207 identified by password;
create user PM37211208 identified by password;
create user PM37211209 identified by password;
create user PM37211210 identified by password;
create user PM37211211 identified by password;
create user PM37211212 identified by password;
create user PM37211213 identified by password;
create user PM37211215 identified by password;
create user PM37211216 identified by password;
create user PM37211217 identified by password;
create user PM37211218 identified by password;
create user PM37211219 identified by password;
create user PM37211220 identified by password;
create user PM37211221 identified by password;
create user PM37211223 identified by password;
create user PM37211224 identified by password;
create user PM37211225 identified by password;
create user PM37211226 identified by password;
create user PM37211227 identified by password;
create user PM37211228 identified by password;
create user PM37211301 identified by password;
create user PM37211302 identified by password;
create user PM37211303 identified by password;
create user PM37211304 identified by password;
create user PM37211305 identified by password;
create user PM37211306 identified by password;
create user PM37211307 identified by password;
create user PM37211308 identified by password;
create user PM37211309 identified by password;
create user PM37211310 identified by password;
create user PM37211311 identified by password;
create user PM37211312 identified by password;
create user PM37211313 identified by password;
create user PM37211314 identified by password;
create user PM37211315 identified by password;
create user PM37211316 identified by password;
create user PM37211317 identified by password;
create user PM37211318 identified by password;
create user PM37211319 identified by password;
create user PM37211320 identified by password;
create user PM37211321 identified by password;
create user PM37211322 identified by password;
create user PM37211323 identified by password;
create user PM37211324 identified by password;
create user PM37211326 identified by password;
create user PM37211327 identified by password;
create user PM37211328 identified by password;
create user PM56000212 identified by password;
create user PM56000217 identified by password;
create user PM56000232 identified by password;

grant connect, resource to PM31415926 identified by password;
grant connect, resource to PM36211124 identified by password;
grant connect, resource to PM37211101 identified by password;
grant connect, resource to PM37211102 identified by password;
grant connect, resource to PM37211103 identified by password;
grant connect, resource to PM37211104 identified by password;
grant connect, resource to AM37211401 identified by password;
grant connect, resource to AM37211402 identified by password;
grant connect, resource to AM37211404 identified by password;
grant connect, resource to AM37211405 identified by password;
grant connect, resource to AM37211406 identified by password;
grant connect, resource to AM37211407 identified by password;
grant connect, resource to AM37211408 identified by password;
grant connect, resource to AM37211409 identified by password;
grant connect, resource to AM37211410 identified by password;
grant connect, resource to AM37211411 identified by password;
grant connect, resource to AM37211412 identified by password;
grant connect, resource to AM37211413 identified by password;
grant connect, resource to AM37211414 identified by password;
grant connect, resource to AM37211415 identified by password;
grant connect, resource to AM37211416 identified by password;
grant connect, resource to AM37211417 identified by password;
grant connect, resource to AM37211418 identified by password;
grant connect, resource to AM37211419 identified by password;
grant connect, resource to AM37211420 identified by password;
grant connect, resource to AM37211421 identified by password;
grant connect, resource to AM37211422 identified by password;
grant connect, resource to AM37211425 identified by password;
grant connect, resource to AM37211426 identified by password;
grant connect, resource to AM37211427 identified by password;
grant connect, resource to AM37211501 identified by password;
grant connect, resource to AM37211502 identified by password;
grant connect, resource to AM37211503 identified by password;
grant connect, resource to AM37211504 identified by password;
grant connect, resource to AM37211505 identified by password;
grant connect, resource to AM37211506 identified by password;
grant connect, resource to AM37211507 identified by password;
grant connect, resource to AM37211508 identified by password;
grant connect, resource to AM37211509 identified by password;
grant connect, resource to AM37211510 identified by password;
grant connect, resource to AM37211511 identified by password;
grant connect, resource to AM37211512 identified by password;
grant connect, resource to AM37211513 identified by password;
grant connect, resource to AM37211514 identified by password;
grant connect, resource to AM37211515 identified by password;
grant connect, resource to AM37211516 identified by password;
grant connect, resource to AM37211517 identified by password;
grant connect, resource to AM37211518 identified by password;
grant connect, resource to AM37211519 identified by password;
grant connect, resource to AM37211520 identified by password;
grant connect, resource to AM37211521 identified by password;
grant connect, resource to AM37211522 identified by password;
grant connect, resource to AM37211523 identified by password;
grant connect, resource to AM37211524 identified by password;
grant connect, resource to AM37211525 identified by password;
grant connect, resource to AM37211526 identified by password;
grant connect, resource to AM37211527 identified by password;
grant connect, resource to AM37211530 identified by password;
grant connect, resource to AM56000248 identified by password;
grant connect, resource to AM56000255 identified by password;
grant connect, resource to PM37211222 identified by password;
grant connect, resource to AM36211320 identified by password;
grant connect, resource to AM37211423 identified by password;
grant connect, resource to PM37211119 identified by password;
grant connect, resource to PM37211325 identified by password;
grant connect, resource to AM35211119 identified by password;
grant connect, resource to PM35211215 identified by password;
grant connect, resource to PM36211508 identified by password;
grant connect, resource to PM37211105 identified by password;
grant connect, resource to PM37211106 identified by password;
grant connect, resource to PM37211107 identified by password;
grant connect, resource to PM37211108 identified by password;
grant connect, resource to PM37211109 identified by password;
grant connect, resource to PM37211110 identified by password;
grant connect, resource to PM37211111 identified by password;
grant connect, resource to PM37211112 identified by password;
grant connect, resource to PM37211113 identified by password;
grant connect, resource to PM37211114 identified by password;
grant connect, resource to PM37211115 identified by password;
grant connect, resource to PM37211116 identified by password;
grant connect, resource to PM37211117 identified by password;
grant connect, resource to PM37211118 identified by password;
grant connect, resource to PM37211120 identified by password;
grant connect, resource to PM37211121 identified by password;
grant connect, resource to PM37211122 identified by password;
grant connect, resource to PM37211123 identified by password;
grant connect, resource to PM37211124 identified by password;
grant connect, resource to PM37211125 identified by password;
grant connect, resource to PM37211126 identified by password;
grant connect, resource to PM37211127 identified by password;
grant connect, resource to PM37211128 identified by password;
grant connect, resource to PM37211201 identified by password;
grant connect, resource to PM37211202 identified by password;
grant connect, resource to PM37211203 identified by password;
grant connect, resource to PM37211204 identified by password;
grant connect, resource to PM37211205 identified by password;
grant connect, resource to PM37211206 identified by password;
grant connect, resource to PM37211207 identified by password;
grant connect, resource to PM37211208 identified by password;
grant connect, resource to PM37211209 identified by password;
grant connect, resource to PM37211210 identified by password;
grant connect, resource to PM37211211 identified by password;
grant connect, resource to PM37211212 identified by password;
grant connect, resource to PM37211213 identified by password;
grant connect, resource to PM37211215 identified by password;
grant connect, resource to PM37211216 identified by password;
grant connect, resource to PM37211217 identified by password;
grant connect, resource to PM37211218 identified by password;
grant connect, resource to PM37211219 identified by password;
grant connect, resource to PM37211220 identified by password;
grant connect, resource to PM37211221 identified by password;
grant connect, resource to PM37211223 identified by password;
grant connect, resource to PM37211224 identified by password;
grant connect, resource to PM37211225 identified by password;
grant connect, resource to PM37211226 identified by password;
grant connect, resource to PM37211227 identified by password;
grant connect, resource to PM37211228 identified by password;
grant connect, resource to PM37211301 identified by password;
grant connect, resource to PM37211302 identified by password;
grant connect, resource to PM37211303 identified by password;
grant connect, resource to PM37211304 identified by password;
grant connect, resource to PM37211305 identified by password;
grant connect, resource to PM37211306 identified by password;
grant connect, resource to PM37211307 identified by password;
grant connect, resource to PM37211308 identified by password;
grant connect, resource to PM37211309 identified by password;
grant connect, resource to PM37211310 identified by password;
grant connect, resource to PM37211311 identified by password;
grant connect, resource to PM37211312 identified by password;
grant connect, resource to PM37211313 identified by password;
grant connect, resource to PM37211314 identified by password;
grant connect, resource to PM37211315 identified by password;
grant connect, resource to PM37211316 identified by password;
grant connect, resource to PM37211317 identified by password;
grant connect, resource to PM37211318 identified by password;
grant connect, resource to PM37211319 identified by password;
grant connect, resource to PM37211320 identified by password;
grant connect, resource to PM37211321 identified by password;
grant connect, resource to PM37211322 identified by password;
grant connect, resource to PM37211323 identified by password;
grant connect, resource to PM37211324 identified by password;
grant connect, resource to PM37211326 identified by password;
grant connect, resource to PM37211327 identified by password;
grant connect, resource to PM37211328 identified by password;
grant connect, resource to PM56000212 identified by password;
grant connect, resource to PM56000217 identified by password;
grant connect, resource to PM56000232 identified by password;

create view PM31415926.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM36211124.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211101.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211102.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211103.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211104.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211401.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211402.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211404.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211405.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211406.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211407.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211408.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211409.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211410.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211411.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211412.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211413.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211414.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211415.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211416.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211417.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211418.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211419.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211420.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211421.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211422.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211425.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211426.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211427.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211501.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211502.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211503.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211504.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211505.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211506.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211507.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211508.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211509.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211510.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211511.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211512.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211513.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211514.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211515.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211516.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211517.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211518.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211519.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211520.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211521.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211522.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211523.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211524.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211525.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211526.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211527.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211530.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM56000248.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM56000255.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211222.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM36211320.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM37211423.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211119.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211325.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view AM35211119.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM35211215.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM36211508.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211105.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211106.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211107.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211108.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211109.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211110.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211111.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211112.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211113.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211114.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211115.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211116.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211117.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211118.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211120.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211121.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211122.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211123.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211124.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211125.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211126.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211127.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211128.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211201.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211202.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211203.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211204.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211205.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211206.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211207.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211208.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211209.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211210.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211211.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211212.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211213.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211215.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211216.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211217.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211218.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211219.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211220.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211221.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211223.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211224.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211225.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211226.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211227.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211228.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211301.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211302.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211303.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211304.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211305.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211306.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211307.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211308.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211309.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211310.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211311.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211312.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211313.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211314.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211315.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211316.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211317.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211318.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211319.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211320.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211321.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211322.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211323.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211324.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211326.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211327.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM37211328.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM56000212.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM56000217.mygrades as select * from fall2009.studentrecords where student_id = USER;
create view PM56000232.mygrades as select * from fall2009.studentrecords where student_id = USER;