oracle數(shù)據(jù)庫的安全與管理(文件)
【正文】 導(dǎo)原則 PAY_CLERK PAY_CLERK_RO 缺省角色 非缺省保護的口令 查詢權(quán)限 插入 , 更新 , 刪除 和查詢權(quán)限 顯示角色信息 角色視圖 說明 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. ? 用戶管理 ? 環(huán)境文件管理 ? 權(quán)限管理 ? 角色管理 ? 常用工具的使用 Oracle數(shù)據(jù)庫的安全與管理 主要內(nèi)容 –實例管理程序 Instance Manager –模式管理程序 Schema Manager –安全管理程序 Security Manager –存儲管理程序 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) 在會話層設(shè)置資源限制 資源 CPU_PER_CALL LOGICAL_READS_PER _CALL 說明 CPU time per call in hundredths of seconds Number of data blocks 在調(diào)用層設(shè)置資源限制 為用戶分配資源文件 CREATE USER user3 IDENTIFIED BY user3 DEFAULT TABLESPACE data01 TEMPORARY TABLESPACE temp QUOTA unlimited ON data01 PROFILE develope
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1