Ingres MDB Considerations (CA MDB r1.0.4) › Define Ingres User IDs (CA MDB r1.0.4) › Create a New User to Administer the CA MDB for r1.0.4

Create a New User to Administer the CA MDB for r1.0.4

A new Ingres user may be created who is able to impersonate the MDB administrative user (mdbadmin). This impersonation is valid for all Ingres commands that support the specification of a user, typically those using a -u parameter. The Ingres SQL command is a good example of this.

Other commands such as the Ingres checkpoint command (ckpdb) also support the -u parameter.

To create an administrative user

1. Create an operating system user ID for the Ingres user to be defined. The OS user ID must conform to Ingres user naming conventions.
2. Create an Ingres user with the following default privileges (createdb, security, operator, maintain_locations, maintain_users). This may be done by using accessdb, the SQL command or Visual DBA.

   To create a user, use the following SQL commands:

   create user username with default privileges=(createdb,security,operator,maintain_locations,maintain_users) \g 
   

   grant db_admin on database mdb to user username \g
   

   These statements need to be issued from the database server by the OS user that installed Ingres/MDB. In addition the command line for the SQL command is:

   sql iidbdb -u$ingres
   

   Note: The connection in this case is made to the Ingres installation database, not the MDB.