{"id":2303,"date":"2014-12-18T19:32:24","date_gmt":"2014-12-18T19:32:24","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2303"},"modified":"2014-12-18T19:33:49","modified_gmt":"2014-12-18T19:33:49","slug":"p-odbc-security-features","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/p-odbc-security-features\/","title":{"rendered":"ODBCSecurity Features"},"content":{"rendered":"<p class=\"basic\" align=\"left\">By default, ODBC, relies on MPE\/iX and TurboImage Database for allowing login and data access. The ODBC security features can provide extra security checking beyond MPE\/iX and TurboImage Database security. ODBC can extend login security by password validation through VESoft, Inc.\u2019s Security\/3000. ODBC can also check data access through a system wide security catalog.<\/p>\n<p class=\"basic\" align=\"left\">The security catalog is created with the Catalog Editor, which is a part of the ODBC software. The security catalog is a matrix of data identifiers ( schemas, tables, and columns ) along with user names which have access to those data identifiers. When the catalog is enabled, a user must be on the list of users for a data identifier to have any sort of access to the data named by the data identifier. The user name can be the MPE\/iX user and account or it can be an arbitrary 16 character name called a catalog user name.<\/p>\n<h4 class=\"subheads\" align=\"left\">Security Configuration<\/h4>\n<p class=\"basic\" align=\"left\">The &#8220;Security&#8221; tab on the ODBC\u2019s data source configuration dialog contains the fields for a Security\/3000 password and a catalog user name.<\/p>\n<p class=\"basic\" align=\"left\">If a \u2018?\u2019 is the first character in any of these fields, this dialog will prompt for the actual entries when the driver connects to the server.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/12\/odbc_scr.gif\" alt=\"\" width=\"380\" height=\"245\" \/><\/p>\n<h4 class=\"subheads\" align=\"left\">Enabling Security checking through the Catalog<\/h4>\n<p class=\"basic\" align=\"left\">In order to use the extra security checking of a catalog file, MSJOB must be modified . The \u2018C\u2019 parameter must be added to the MSSERVER000004 variable, as shown below:<\/p>\n<p class=\"basic\" align=\"left\">!SETVAR MSSERVER000004 &#8220;30006 0 ODBCSRVR.MM.MINISOFT S C&#8221;<\/p>\n<p class=\"basic\" align=\"left\">A catalog file must then be created with the Catalog Editor and uploaded to the server. The server program accesses the catalog file through the formal designator &#8220;ODBCCAT&#8221;. A file equation may be placed in MSJOB, before the &#8220;!RUN&#8221; line, to reference the proper file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By default, ODBC, relies on MPE\/iX and TurboImage Database for allowing login and data access. The ODBC security features can provide extra security checking beyond MPE\/iX and TurboImage Database security. ODBC can extend login security by password validation through VESoft, Inc.\u2019s Security\/3000. ODBC can also check data access through a system wide security catalog. The [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2303"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2303"}],"version-history":[{"count":2,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2303\/revisions"}],"predecessor-version":[{"id":2305,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2303\/revisions\/2305"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}