6.2.5 Review Roles Granted to PUBLIC

Information

Granting to PUBLIC increases the risk of unauthorized entry into the database. Because PUBLIC is accessible by any database user, it is important to understand the exposure it has on all database objects. It would make sense to grant role membership to PUBLIC if all users required all the privileges granted through that role.

Rationale:

As any role granted to PUBLIC can potentially allow the compromise of database availability, confidentiality, or integrity, these roles should be restricted according to the needs of the business.

Solution

To remove a role member from a particular role:

Connect to Db2 database:

db2 => connect to <dbname>

Run the following:

db2 => revoke role <role name> from PUBLIC

See Also

https://workbench.cisecurity.org/benchmarks/10752

Item Details

Category: ACCESS CONTROL, MEDIA PROTECTION

References: 800-53|AC-3, 800-53|AC-5, 800-53|AC-6, 800-53|MP-2, CSCv7|14.6

Plugin: IBM_DB2DB

Control ID: b7347f75003f1357e23f053875a03b88b0b8dbdda77df73b843674017f4434ba