oracle數(shù)據(jù)庫(kù)的安全與管理(文件)
【正文】 導(dǎo)原則 PAY_CLERK PAY_CLERK_RO 缺省角色 非缺省保護(hù)的口令 查詢(xún)權(quán)限 插入 , 更新 , 刪除 和查詢(xún)權(quán)限 顯示角色信息 角色視圖 說(shuō)明 DBA_ROLES All roles which exist in the database DBA_ROLE_PRIVS Roles granted to users and roles ROLE_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 roles ROLE_TAB_PRIVS Table privileges granted to roles SESSION_ROLES Roles which the user currently has enabled. ? 用戶(hù)管理 ? 環(huán)境文件管理 ? 權(quán)限管理 ? 角色管理 ? 常用工具的使用 Oracle數(shù)據(jù)庫(kù)的安全與管理 主要內(nèi)容 –實(shí)例管理程序 Instance Manager –模式管理程序 Schema Manager –安全管理程序 Security Manager –存儲(chǔ)管理程序 Storage Manager –備份管理程序 Backup Manager –網(wǎng)絡(luò)配置程序 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_manager IDENTIFIED 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。 Resource CPU_PER_SESSION SESSIONS_PER_USER CONNECT_TIME IDLE_TIME LOGICAL_READS_PER _SESSION PRIVATE_SGA Description Total CPU time measured in hundredths of seconds Number of concurrent sessions allowed for each username Elapsed connect time measured in minutes Periods of inactive time measured in minutes Number of data blocks (physical and logical reads) Private space in the SGA measured in bytes (for MTS only) 在會(huì)話層設(shè)置資源限制 資源 CPU_PER_CALL LOGICAL_READS_PER _CALL 說(shuō)明 CPU time per call in hundredths of seconds Number of data blocks 在調(diào)用層設(shè)置資源限制 為用戶(hù)分配資源文件 CREATE USER user3 IDENTIFIED BY user3 DEFAULT TABLESPACE data01 TEMPORARY TABLESPACE temp QUOTA unlimited ON data01 PROFILE develope
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號(hào)-1