实验七数据库安全性实验

《实验七数据库安全性实验》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、实验七数据库安全性实验一、实验目的学习巩固课本第四章数据库安全性知识，练习Grant语句IjRevote语句。二、实验内容课本P148第8、9题（除c小题外）。三.概要设计略。四、主要SQL语句一数据•库安全性实验(Grant、Revote语句练习。课本P148第、题，除c小题外)createtableD(dnochar(20)primarykey,dnamechar(20),mnchar(20),addrchar(200)ztelchar(20))；createtableE(enochar(20)primarykey,enamechar(20),eagesmallint,

2、jobchar(20)zesaint,dnochar(20),foreignkey(dno)referencesD(dno)一第题——atoWangMingtoWangMingtoLiYongtoLiYonggrantselectonobject::Egrantselectonobject::D--bgrantinsertonobject::Egrantdeleteonobject::Egrantinsertonobject::DtoLiYonggrantdeleteonobject::DtoLiYong—C(不做)—dgrantselectonobject::EtoLiu

3、Xinggrantupdmteonobject::E(esa)toLiuXing--对歹0的授权--egrantalteronobject::EtoZhangXingrantalteronobject::DtoZhangXin—f不建议用allzW以利用视图化界面grantselectonobject::EtoZhouPingwithgrantoptiongrantselectonobject::DtoZhouPingwithgrantoptiongrantinsertonobject::EtoZhouPingwithgrantoptiongrantinsertonobje

4、ct::DtoZhouPingwithgrantoptiongrantupdmteonobject::EtoZhouPingwithgrantoptiongrantupdateonobject::DtoZhouPingwithgrantoptiongrantdeleteonobject::EtoZhouPingwithgrantoptiongrantdeleteonobject::DtoZhouPingwithgrantoption--g利用视图来做createviewsal(hi_sal,lo_sal,avg_sal)asselectmax(esa),min(esa),a

5、vg(esa)fromEgrantselectonobject::saltoYangLan--第9题revokeselectonobject::Etorevokeselectonobject::Dto--brevokeinsertonobject::Etorevokedeleteonobject::Etorevokeinsertonobject::Dtorevokedeleteonobject::Dto—C(不做)——drevokeselectonobject::Etorevokeupdateonobject::E(esa)WangMingWangMingLiYongLiY

6、ongLiYongLiYongLiuXingtoLiuXing——erevokealteronobject::EtoZhangXinrevokealteronobject::DtoZhangXinrevokeselectonobject::EtoZhouPingcascade——withgrantoptionrevokeselectonobject::DtoZhouPingcascade——withgrantoptionrevokeinsertonobject::EtoZhouPingcascade——withgrantoptionrevokeinsertonobject:

7、:DtoZhouPingcascade——withgrantoptionrevokeupdateonobject::EtoZhouPingcascade——withgrantoptionrevokeupdateonobject::DtoZhouPingcascade——withgrantoptionrevokedeleteonobject::EtoZhouPingcascade--withgrantoptionrevokedeleteonobject::DtoZhouPingcascade——withgrantop