Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is it ok to create my DB2 database for CLM with the 'restrictive' flag?

Questions
Tags
Users
Badges
Josh Crawford
(984●6●15) edited
Jun 04 '13, 1:44 p.m.
My DBA's use the restrictive as part of our process to create all of our DB2 databases.  I notice the CLM infocenter instructions do not mention if this is ok.  Should I be concerned? 

The restrictive option is documented here:
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html

And defined as:
RESTRICTIVE
If the RESTRICTIVE option is present it causes the restrict_access database configuration parameter to be set to YES and no privileges or authorities are automatically granted to PUBLIC. If the RESTRICTIVE option is not present then the restrict_access database configuration parameter is set to NO and privileges are automatically granted to PUBLIC. For information about privileges, see: "Default privileges granted on creating a database".

0 votes

1 answer
5,806 views
0 votes

One answer

Permanent link
Josh Crawford
(984●6●15) Jun 04 '13, 1:42 p.m.
 At this time there are no known issues with the use of that flag for database creation.  None of the CLM applications including the reporting tools require public access to the database so this flag should be safe to use. 

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121
× 2,357
× 84

Question asked: Jun 04 '13, 1:41 p.m.

Question was seen: 5,806 times

Last updated: Jun 04 '13, 1:44 p.m.

Confirmation Cancel Confirm