第十四色管理.ppt

角色管理 本章目的 学完本章之后，要掌握以下的内容: 建立与修改角色 移除角色 使用预定义的角色 从数据字典查询角色信息 角色 角色的作用 减少分配权限的工作 建立角色 使用预定义的角色 分配角色 从用户删除角色 删除角色 显示角色信息 总结 在本章，我们学会如何: 建立角色 分配权限给角色 分配角色给用户或角色 14-* 14 用户 权限 角色 UPDATE ON EMP INSERT ON EMP SELECT ON EMP CREATE TABLE CREATE SESSION HR_CLERK HR_MGR A B C CREATE ROLE sales_clerk; Role Name Description CONNECT, These two roles are providedRESOURCE for backward compatibility. DBA All system privileges WITH ADMIN OPTION EXP_FULL_DATABASE Privileges to export the database IMP_FULL_DATABASE Privileges to import the database DELETE_CATALOG_ROLE DELETE privileges on data dictionary tables EXECUTE_CATALOG_ROLE EXECUTE privilege on data dictionary packages SELECT_CATALOG_ROLE SELECT privilege on data dictionary tables GRANT hr_clerk, TO hr_manager; GRANT sales_clerk TO scott; GRANT hr_manager TO scottWITH ADMIN OPTION; REVOKE hr_manager FROM PUBLIC; REVOKE sales_clerk FROM scott; DROP ROLE hr_manager; Role View Description DBA_ROLES All roles that exist in the database DBA_ROLE_PRIVS Roles granted to users and roles ROLE_ROLE_PRIVS Roles that are granted to roles DBA_SYS_PRIVS System privileges granted to users and roles ROLE_SYS_PRIVS System privileges granted to roles ROLE_TAB_PRIVS Table privileges granted to roles SESSION_ROLES Roles that the user currently has enabled Schedule: Timing Topic 30 minutes Lecture 20 minutes Practice 50 minutes Total Oracle8: Database Administration 18-* Oracle8: Database Administration 18-* 14-* Schedule: Timing Topic 30 minutes Lecture 20 minutes Practice 50 minutes Total