Previous Topic: Set Ingres Configuration Parameters (CA MDB r1.0.4)

Next Topic: Enable an Existing User to Administer the CA MDB for r1.0.4

Define Ingres User IDs (CA MDB r1.0.4)

To connect to an Ingres MDB, you must possess a valid Ingres user ID and an associated valid user ID on the operating system that hosts the Ingres database server.

The Management Database is created with all of the pre-defined Ingres user IDs required by CA products to access the database. A user ID is not accessible until an operating system user ID with the same user name is created on the database server with the MDB. The operating system user IDs are not created until the product is installed. If you have one CA product accessing the Management Database, the database server will have defined only the operating system user IDs required for that product. Ingres user IDs are defined without passwords, because Ingres authenticates the operating system user definition before checking whether the user is defined to Ingres.

Some product installations create operating system users when the product is installed. In such cases, product installation should prompt for the password to be used in creating the OS user ID. Whenever possible, it should refrain from creating the password automatically, or (if created automatically) it should be a strong password.

Important! The Ingres user ID mdbadmin is the administrative owner of all MDB database objects. This user name should not have a corresponding operating system user ID; if it did, it would expose the Management Database to administration and access from remote sources. This user name should not be used by any product to access objects in the Management Database, as it is for CA internal use only. If such an operating system user is found, it should be investigated and ultimately removed.