數(shù)據(jù)庫(kù)實(shí)驗(yàn)四報(bào)告-在線瀏覽
2024-09-14 00:44本頁(yè)面
【正文】 create any index的權(quán)限。drop table 。create view asselect ,gradefrom student,sc,coursewhere = and = and major=39。select ,gradefrom student,sc,coursewhere = and = and major=39。執(zhí)行結(jié)果：5．用系統(tǒng)帳戶sys登錄數(shù)據(jù)庫(kù)，創(chuàng)建用戶user_three，將角色權(quán)限D(zhuǎn)BA授予用戶user_three，并將S、P、J、SPJ四張表導(dǎo)入到user_three模式下。grant dba to user_three。（1）把對(duì)表S的INSERT權(quán)力授予用戶user_one，并允許他再將此權(quán)限授予其他用戶。執(zhí)行結(jié)果：（2）用戶user_two對(duì)S，P，J三個(gè)表有SELECT和INSERT權(quán)力語句：grant select,insert on s to user_two。grant select,insert on j to user_two。語句：grant delete,update(qty) on spj to user_one。語句：revoke insert on s from user_one。（系統(tǒng)權(quán)限和對(duì)象權(quán)限應(yīng)該分別收回）語句：revoke creat
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1