www.mimer.com/developer

Mimer SQL Idents

---

There are four kinds of ident in Mimer SQL:

• USER

  USER idents are authorized to connect to a Mimer SQL database, by using the CONNECT statement in an application program or by entering the correct ident name and password in an interactive environment.

  Any privileges a user ident holds may be exercised once the ident has logged on. User idents are generally associated with specific physical individuals authorized to connect to the database.

• OS_USER

  OS_USER is an ident type which allows the user currently logged in to the operating system to connect to a Mimer SQL database without providing a username or password.

  If an OS_USER ident is defined with a password in Mimer SQL, the ident may connect to Mimer SQL in the same way as any other user ident (i.e. by providing a username and password). An OS_USER ident is subject to the same access restrictions as any other user ident.

• PROGRAM

  PROGRAM idents may not initiate a connection to a Mimer SQL database, but may be entered from within an application program or interactive environment by using the ENTER statement.

  A connection should have been established before the ENTER statement is used, see Connecting to a Database. Entering a program ident is analogous to logging on as a user ident, in that the program ident gains access to the system and any privileges the ident holds become applicable. Program idents are generally associated with specific functions within the system, not with physical individuals.

• GROUP

  GROUP idents are collective identities for groups of user or program idents. Any privileges granted to or revoked from a group ident automatically apply to all members of the group. Any ident can be a member of as many groups as required, and one group can include any number of members. Group idents provide a facility for organizing the privilege structure in the database system.

USER, OS_USER and PROGRAM idents are authorized users of the system.

Every USER and PROGRAM ident has a unique ident name and a private password which must be correctly supplied to the CONNECT or ENTER statement in application programs.

An OS_USER may access the database without explicitly providing a username or password on condition that the username for the user currently logged in to the operating system correspond to the definition of an OS_USER in the Mimer SQL database.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se