oracle數(shù)據(jù)庫的安全與管理培訓教材(文件)
【正文】 n the databaseDBA_ROLE_PRIVS Roles granted to users and rolesROLE_ROLE_PRIVS Roles which are granted to roles DBA_SYS_PRIVS System privileges granted to users and roles ROLE_SYS_PRIVS System privileges granted to rolesROLE_TAB_PRIVS Table privileges granted to rolesSESSION_ROLES Roles which the user currently has enabled. ? 用戶管理? 環(huán)境文件管理? 權(quán)限管理? 角色管理? 常用工具的使用Oracle數(shù)據(jù)庫的安全與管理主要內(nèi)容– 實例管理程序 Instance Manager– 模式管理程序 Schema Manager– 安全管理程序 Security Manager– 存儲管理程序 Storage Manager– 備份管理程序 Backup Manager– 網(wǎng)絡配置程序 Net Easy Configuration演講完畢，謝謝觀看！。REVOKE sales_clerk FROM scott。SET ROLE sales_clerk IDENTIFIED BY mission。ALTER USER scott DEFAULT ROLE ALL。分配角色GRANT hr_clerk, TO hr_manager。CREATE ROLE hr_managerIDENTIFIED EXTERNALLY。GRANT UPDATE(ename,sal) ON emp TO user1 WITH GRANT OPTION。GRANT CREATE SESSION TO scott WITH ADMIN OPTION。刪除環(huán)境文件DROP PROFILE developer_prof。ResourceCPU_PER_SESSION SESSIONS_PER_USERCONNECT_TIME IDLE_TIME LOGICAL_READS_PER _SESSIONPRIVATE_SGA DescriptionTotal CPU time measured in hundredths of secondsNumber of concurrent sessions allowed for each usernameElapsed connect time measured in minutesPeriods of inactive time measured in minutesNumber of data blocks (physical and logical reads)Private space in the SGA measured in bytes (for MTS only)在會話層設(shè)置資源限制 資源CPU_PER_CALLLOGICAL_READS_PER _CALL說明CPU time per call in hundredths of secondsNumber of data blocks在調(diào)用層設(shè)置資源限制為用戶分配資源文件CREATE USER user3 IDENTIFIED BY user3DEFAULT TABLESPACE data01TEMPORARY TABLESPACE tempQUOTA unlimited ON data01 PROFILE developer_prof。修改用戶的表空間定額ALTER USER p
語文相關(guān)推薦
鄂ICP備17016276號-1