Start of Content Area

Procedure documentation Setting Up SAPDBA Users  Locate the document in its SAP Library structure

Procedure

  1. Assign your database administrators to expert or non-expert mode. Note that users working in expert mode can perform all SAPDBA actions, whereas users working in non-expert mode are restricted to simpler actions that cannot endanger the database.

    2. How you implement this feature depends on your operating system, as shown in the following table:

    Expert and Non-Expert Mode in SAPDBA
     

    Expert mode

    Non-expert mode

    UNIX

    User informix

    Normally user <sid>adm , although other users in this group are also treated as non-experts. SAPDBA regards any user in the group sapsys to be non-expert.

    NT

    User informix

    All users except informix .

    Note

    On UNIX platforms, SAPDBA can only be started by the user informix or by any user in the sapsys group.

    The rest of this procedure only applies if your operating system is UNIX. For more information about setting environment variables, see Setting Up SAPDBA Environment Variables.

    SAPDBA is set up to run for the users informix and <sid>adm .

  2. You need to only set the environment variables SAPDBA_LANGUAGE and TERM for the users informix and <sid>adm .
  3. Make sure that all necessary environment variables are correctly set for other authorized users (that is, users in the group sapsys who are not <sid>adm ).