數(shù)據(jù)庫系統(tǒng)原理與開發(fā)-PostgreSQL數(shù)據(jù)庫管理項(xiàng)目實(shí)踐

PostgreSQL數(shù)據(jù)庫管理項(xiàng)目實(shí)踐數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用本節(jié)學(xué)目地?掌握數(shù)據(jù)庫系統(tǒng)角色創(chuàng)建方法?掌握賦予數(shù)據(jù)庫角色對象訪問權(quán)限方法?掌握創(chuàng)建數(shù)據(jù)庫用戶及其角色賦予方法?掌握系統(tǒng)數(shù)據(jù)庫備份方法?掌握系統(tǒng)數(shù)據(jù)庫恢復(fù)方法一數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用一,項(xiàng)目案例——成績管理系統(tǒng)本節(jié)結(jié)合一個"成績管理系統(tǒng)"項(xiàng)目案例地?cái)?shù)據(jù)庫管理,學(xué)PostgreSQL數(shù)據(jù)庫管理操作,理解與掌握本章所學(xué)地安全管理,數(shù)據(jù)庫備份與恢復(fù)管理等技術(shù)方法。?學(xué)生信息表（Student）?教師信息表（Teacher）成績管理數(shù)據(jù)庫?課程信息表（Course）GradeDB?成績記錄表（Grade）二數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用二,數(shù)據(jù)庫角色管理根據(jù)成績管理系統(tǒng)需求,本系統(tǒng)設(shè)計(jì)三類數(shù)據(jù)庫角色:學(xué)生（R_Student）,教師（R_Teacher）與教務(wù)員（R_TAdmin）。CREATEROLE"R_Student"WITH--創(chuàng)建學(xué)生角色LOGINCONNECTIONLIMIT-一;CREATEROLE"R_Teacher"WITH--創(chuàng)建教師角色LOGINCONNECTIONLIMIT-一;CREATEROLE"R_TAdmin"WITH--創(chuàng)建教務(wù)員角色LOGINCONNECTIONLIMIT-一;三數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用角色創(chuàng)建SQL程序執(zhí)行四數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用三,數(shù)據(jù)庫角色權(quán)限設(shè)計(jì)與實(shí)現(xiàn)五數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用賦予各個角色地?cái)?shù)據(jù)庫對象訪問權(quán)限SQL程序GRANTSELECTONSTUDENTTO"R_Student";GRANTSELECTONTEACHERTO"R_Student";GRANTSELECTONCOURSETO"R_Student";GRANTSELECTONGRADETO"R_Student";GRANTSELECTONSTUDENTTO"R_Teacher";GRANTSELECTONTEACHERTO"R_Teacher";GRANTSELECTONCOURSETO"R_Teacher";GRANTSELECT,INSERT,UPDATE,DELETEONGRADETO"R_Teacher";GRANTSELECT,INSERT,UPDATE,DELETEONSTUDENTTO"R_TAdmin";GRANTSELECT,INSERT,UPDATE,DELETEONTEACHERTO"R_TAdmin";GRANTSELECT,INSERT,UPDATE,DELETEONCOURSETO"R_TAdmin";GRANTSELECT,INSERT,UPDATE,DELETEONGRADETO"R_TAdmin";六數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用角色授權(quán)SQL程序執(zhí)行七數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用四,數(shù)據(jù)庫用戶管理本系統(tǒng)創(chuàng)建一個學(xué)生用戶（StudentUser）與一個教師用戶（TeacherUser）,并分別賦予學(xué)生角色（R_Student）與R_Teacher）,初始密碼為一二三四五六。CREATEUSER"StudentUser"WITHLOGINCONNECTIONLIMIT-一INROLE"R_Student"PASSWORD'一二三四五六';CREATEUSER"TeacherUser"WITHLOGINCONNECTIONLIMIT-一INROLE"R_Teacher"PASSWORD'一二三四五六';八數(shù)據(jù)庫系統(tǒng)原理與開發(fā)數(shù)據(jù)庫原理及應(yīng)用用戶創(chuàng)建SQL程序執(zhí)