欢迎来到天天文库
浏览记录
ID:30880175
大小:408.76 KB
页数:8页
时间:2019-01-04
《实验七数据库安全性实验》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
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
此文档下载收益归作者所有