Review Roles

中等級 1人工審核db2

說明

Roles provide several advantages that make it easier to manage privileges in a database system. Security administrators can control access to their databases in a way that mirrors the structure of their organizations (they can create roles in the database that map directly to the job functions in their organizations). The assignment of privileges is simplified. Instead of granting the same ...

檢查方式

稽核方法: 人工審核

此項建議無法自動檢查。當您傳入 --include-manual 時，掃描結果會列出此項目並附帶這些說明。

1. Connect to Db2 database: db2 => connect to <dbname> 2. Run the following and review the results to determine if each role name still has a business requirement to access the data: db2 => select rolename from syscat.roleauth where grantortype <> 'S' group by rolename

修補方式

修補方法: 操作指南或基礎設施修補檔

To remove a role from the database: 1. Connect to Db2 database: db2 => connect to <dbname> 2. Run the following: db2 => drop role <role name>

屬性

作業系統: 不限
標籤: db2databasemanual
參考資料: CIS IBM Db2 12.1 Benchmark v1.0.0 - 6.2.2 Review Roles