实验四 数据库安全性与完整性控制

实验题目： 数据库安全性与完整性控制目录TOC\o"1-5"\h\z一、实验目的 1二、实验内容 1三、实验要点及说明 1四、实现方法 1\o"CurrentDocument"五、实验结果 2\o"CurrentDocument"六、源程序清单 4\o"CurrentDocument"七、思考及总结 5一、实验目的通过本次实验，提高以下几个方面的能力1.创建新用户通过GRANT语句对新用户进行授权通过REVOKE语句完成权限的回收实体完整性的实现参照完整性实现二、实验内容1.完成教材中实例1－8完成教材中相应于完整性的实例。三、实验要点及说明一定要熟练掌握GRANT语句与REVOKE语句的使用一定要熟练掌握实体完整性与参照完整性控制要读懂出错的提示信息四、实现方法未将创建的用户删除，有创建同一个用户。C:\TIHD0WS\systeB32\cMd.eze一Bysql一llloot-p ［二「□<C>版权所有1985-2001MicrosoftCorp.C：^DocumentsandSettimgrsXAdministrator>mys(il-uroot-pEnter :减xxxxUbleninetntzhe mninitnip.Conntandsendu±th；mi*Kgf_Voui'M^SQLccnnectionidis3Gei'uei* ion:5=5=B—entei'pi*isfe—coiTmei*cial—aduarcedMj/£QLEnterprise£ei*wei'一AdvanccdEdit：ionCContmGi'cial)Copyright<c)2090^2010>OraclcandZorit：好o£filiates.Allrig-Jitsreserved.Opac1cisaresists：red ofOraclcCorporationandZorit：3ciff .Othierriciniies Jjttrademai'ksuftheir*respectiveynuip■TypeJheIp;Jopb forheIp・T^pe'ytoclearthecurrentInputstatemieiit.Createuser*zhangsan identifiedby‘1”；EKKOR1396<HY«W0>：OperationGKEHIEUSERfailedfop'ahanffsan/nysql?dk.d删除localhost方法mys(il>dpapusep*lisiJlocaLhost"->；Quer-yOK,0rowsaffected<0.90sec>五、实验结果pueryOK,0rowsaffected(S.00sec>inysql>CreateuserJshangsanJJidentifiedbyWMiieryOK,0rowsaffected<0.02sec>mysql>Createuser1zhangsan2J identifiedbypasswordJ*E6CC90B878B948C35E9EB0B3C792C46C58C4AF40,；MiieryOK,0rowsaffected<S.00sec)mysql>Grantallon*.*to1lisifPJlncalhost*identifiedby12J；WueryOK,0rowsaffected<S.00sec>inysql>showschenas；TOC\o"1-5"\h\z+ +iDatabase Iiinformaticn_schem且!!iTt^sql iIperformance_schema!Itest !4rowsinset<S.02sec)创建用户成功licrosoftWindowsXP 5.1.26001<C>扳权所有1985-2001MicrosoftCorp.C：XDocumentsandSettingsMldministFatop^ysql-uzhansrsan一pEnterpassword：*UelconnetotheMySQLmonitoi'.Commandsenduith；of\g-VourMySQL匚onnectionidis4Serveruersion:5.5.8-enterpi'ise-coniFiepcial—advancednsrSQliEntepppiseServer一RduancedEdition<Coinniei'cial>Copyright<c>2000,20L&^Oracleand/oritsaffiliates.Allrightsreserued・OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.OthernanesmajpbetFadenarPsoftheirrespectiueownersjType9help；Jopj\1ijforhelp.TypeJ\cJtoclearthecurrentinputstatement・nysql>登陆用户zhangsanHicrosoftWindowsXP5-1.2600]CO版权所有1985-2001MicrosoftCarp.C：XDocumentsandSe11incfs\Administratof>mi/sq1-uzhangsan2-pEnterpassword：*MelcometotheMySQLnonitop-Connandsendwith；or\g.VourH^pSQLconnectionidis5Serveryersion:5-5.S-enterprise-CDUimepoial~advancedMySQLEnterpriseServer一AduancedEditionCCofiinercial>Copyright<c>2Q0&,2010,OracLeand/oritsaffiliates.Allrightsreserved.UracleisaregisteredtpademapkofOracleCorporationand/oritsaffiliates-Otliei'ruamesma.ybetrademarksoftheirrespectiueowners.Iype*help；Jor1Xli1fophelp.Type*ScJtoclearthecurrentinputstatement.mysql>登陆用户zhangsan2MicrosoftUindousXP[质卒5.1.2600]<C>版权所有1985-2001MicrosoftCopp.C：XDocunientsandSettinjfs\fldmin1strator>mysql-lilisi-pEnterDftssword：*WeleonetotheMySQLnonitor-Commandsendwith；of\g・YourHygQliconnectionidis&Seruepversion：5.5.8-enterprise-coninepcial-aduancedflyEQLEnterpriseServer一AdvancedEditionCCommercial>Copyright<c>2000-2010,Oracleand/oritsaffiliates.Allrightsreserued・OracleisapeejisteredtradenarkofOracleCorparationand/oritsaffiliates.Othernamesmaybetraden且rlc：softheirrespectiveov/ners■Typefhelp；JorJ\}/forhelp.TiipeJ\cftoclearthecurpentinputstatement.mysql>登陆用户lisi

hysql>shouschemas；+ +IDatabase Im5rs：qL>showschemas；m5rs：qL>showschemas；_l 1_IDatabase IIinformation_sclieniaI-i k1rowinset<0.00sec>!inFopmation_schema!ch4InysqlIperfornance_sclie[na!testbrousinset<0.00sec>用户zhangsan用户zhangsan和zhangsan2信息显示用户lisi信息显示niiFsql>grantselect<coll>QueryOK,&rowsaffectedanniiFsql>grantselect<coll>QueryOK,&rowsaffectedanch4toshangsan；C0.S2sec>mysql>gpantseLectCcoll>QueryOK,8r-owsaffectedanch4_ttozhangsanS；CS.00sec>分别给用户zhangsan和zhangsan2授权hysql>showschemas；TOC\o"1-5"\h\z>i +■ Database !_i +I infoi'ina七ijon_s：c]ie!iTbaI! ch4 I_i +z1'qwsinset<0.00sec>授权之后查看zhangsan中信息mysql>grantu.pdate<co11>anch4.ttoahanysanS；Quer^OK,Sr-ousaffectedCO.09sec>hysql>updatecli4■土| ->setcoll=1；ftu.eryOK,Srowsaffected(0.02s：ec：>Rows：matched：SChanged:0 =0修改zhangsan2中数据六、源程序清单Createuser'zhangsan'@'%'identifiedbyT; /*创建用户张三，密码为1*/Createuser'zhangsan2'@'%'identifiedbypassword'*E6CC90B878B948C35E92B003C792C46C58C4AF40'; /*