Chapt08 数据库安全性.pptVIP

* * * * * * * * * * 请结合脚本运行录制pdf文档授课，很多plsql程序的例子无法在课件ppt上展示，这些都在脚本运行录制pdf文档上。 * 建立角色 CREATE ROLE sales_clerk; CREATE ROLE hr_clerk IDENTIFIED BY bonus; * 修改角色 ALTER ROLE hr_manager NOT IDENTIFIED; ALTER ROLE sales_clerk IDENTIFIED BY commission; * 将角色分配给用户 GRANT sales_clerk TO scott; GRANT hr_manager TO scottWITH ADMIN OPTION; * 设置缺省角色 ALTER USER scottDEFAULT ROLE hr_clerk, sales_clerk; ALTER USER scott DEFAULT ROLE ALL; ALTER USER scott DEFAULT ROLE ALL EXCEPT hr_clerk; ALTER USER scott DEFAULT ROLE NONE; * 禁止和激活角色 SET ROLE sales_clerk IDENTIFIED BY commission; SET ROLE ALL EXCEPT sales_