Ingres MDB Considerations (CA MDB r1.0.4) › Define Ingres User IDs (CA MDB r1.0.4) › Enable an Existing User to Administer the CA MDB for r1.0.4

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

An existing user may be given the ability to administer the MDB by impersonating the MDB administrative user (mdbadmin). This is accomplished by using the following SQL commands:

alter 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 operating system user that installed the Ingres MDB. In addition, the command line for the SQL command is:

sql iidbdb -u$ingres

Note: The Ingres Visual DBA tool may be used to create users, alter users and add grants.

For information about creating users with administrative capabilities, see the Ingres Database Administrator Guide.

For information about the create user, alter user, and grant commands, see the Ingres SQL Reference.