Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


An ident is an authorization-id used to identify users, programs and groups. The different types of idents in a Mimer SQL database are USER, PROGRAM and GROUP idents.

USER Idents

USER idents identify individual users who can connect to a Mimer SQL database.

A USER ident's access to the database is usually protected by a password, and is also restricted by the specific privileges granted to the ident. USER idents are generally associated with specific physical individuals who are authorized to use the system.

For a USER ident it is possible to add one or several OS_USER logins which allows the user currently logged in to the operating system to access the Mimer SQL database without providing a password.

For example: if the current operating system user is ALBERT and there is an OS_USER login called ALBERT for an ident in Mimer SQL, ALBERT may start Mimer BSQL (for example) and connect directly to Mimer SQL simply by giving the ident name at the Username: prompt and press <return> at the password: prompt.

If the ident name is the same as the OS_USER login no ident name needs to be given, it is sufficient to press <return> at the username: prompt.

A USER ident may be defined without a password and in that case it is only possible to connect to Mimer SQL by using the OS_USER login. Dropping and adding password and OS_USER logins is done with ALTER IDENT statement.


PROGRAM idents do not strictly connect to Mimer SQL, but they may be entered from within an application program by using the ENTER statement.

The ENTER statement may only be used by an ident who is already connected to a Mimer SQL database.

An ident is granted the privilege to enter a PROGRAM ident. A PROGRAM ident is set up to have certain privileges and these apply after the ENTER statement has been used.

PROGRAM idents are generally associated with specific functions within the system, rather than with physical individuals.

The LEAVE statement is used to return to the state of privileges and database access that existed before ENTER was used.

GROUP Idents

GROUP idents are collective identities used to define groups of USER and/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 a group can include any number of members.

GROUP idents provide a facility for organizing the privilege structure in the database system. All idents are automatically members of a logical group which is specified in Mimer SQL statements by using the keyword PUBLIC.

Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL Documentation TOC PREV NEXT INDEX