Question

1
Replies
97
Views
JiaMingOng Member since 2014 2 posts
Accenture
Posted: June 30, 2017
Last activity: July 10, 2017
Closed

DB2 Security Configuration

We are currently using DB Enterprise Server Edition - DB2COPY1 | Version 9.7.900.250.

If we were implement the following configuration, will there be any impacts?

1. Revoke the IMPLICIT_SCHEMA authority from the PUBLIC group by issuing this SQL statement: "REVOKE IMPLICIT_SCHEMA ON DATABASE FROM PUBLIC;"

2. Encrypted authentication: from an IBM DB2 Console, execute "UPDATE DATABASE MANAGER CONFIGURATION USING AUTHENTICATION [method]"
The following are the secure [method]:
SERVER_ENCRYPT
DATA_ENCRYPT
KRB_SERVER_ENCRYPT
GSS_SERVER_ENCRYPT

3. Configure instance name for discovery requests: from an IBM DB2 Console, execute "UPDATE DATABASE MANAGER CONFIGURATION USING DISCOVER KNOWN"

4. Disable instance discoverability: from an IBM DB2 Console, execute "UPDATE DATABASE MANAGER CONFIGURATION USING DISCOVER_INST DISABLE"

5. Configure the KEEPFENCED parameter: "UPDATE DATABASE MANAGER CONFIGURATION USING KEEPFENCED NO"

Data Integration
Moderation Team has archived post
Share this page LinkedIn