Question

1
Replies
104
Views
Jia Ming Ong (JiaMingOng)
Accenture

Accenture
SG
JiaMingOng Member since 2014 2 posts
Accenture
Posted: June 30, 2017
Last activity: July 10, 2017
Posted: 30 Jun 2017 3:41 EDT
Last activity: 10 Jul 2017 2:31 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.