TMA-DB2-6.1.8
Secure DATAACCESS Authority
Opis
Grants the authority to access data. The DATAACCESS authority allows the grantee to leverage DML level commands i.e. SELECT, INSERT, UPDATE, DELETE, LOAD, and EXECUTE any package or routine. The DATAACCESS authority cannot be granted to PUBLIC.
Kako se proverava
Metod provere: Ručni pregled
Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --include-manual.
1. Run the following command: db2 => select distinct grantee, granteetype from syscat.dbauth where dataaccessauth = 'Y' 2. Review the list of users, groups, and roles in the above output to ensure only approved users, groups, and roles are assigned.
Kako se ispravlja
Metod ispravke: Smernica ili zakrpa infrastrukture
Revoke DATAACCESS authority from any unauthorized users. db2 => REVOKE DATAACCESS ON DATABASE FROM USER <username>
Svojstva
- Operativni sistemi
- Bilo koji
- Oznake
- db2databasemanual
- Referenca
- CIS IBM Db2 12.1 Benchmark v1.0.0 - 6.1.8 Secure DATAACCESS Authority