Mimer SQL Idents
An ident is an authorization-ID used to identify different kinds of users in a Mimer SQL database.
There are four kinds of ident in Mimer SQL:
Idents connect to a database through the
CONNECTstatement and the
ENTERstatement is used to take up the privileges provided by a
PROGRAMident (see below).
PROGRAMident has a unique ident name and a private password which must be correctly supplied to the
ENTERstatement in application programs.
OS_USERident may access the database without explicitly providing a user name or password on condition that the user name for the user currently logged in to the operating system correspond to the definition of the
OS_USERin the Mimer SQL database.
USERidents are authorized to connect to a Mimer SQL database, by using the
CONNECTstatement in an application program or by entering the correct ident name and password in an interactive environment.
Any privileges a
USERident holds may be exercised once the ident has logged on.
USERidents are generally associated with specific physical individuals authorized to connect to the database.
OS_USERis an ident type that allows the user currently logged in to the operating system to connect to a Mimer SQL database without providing a username or password.
OS_USERident is defined with a password in Mimer SQL, the ident may connect to Mimer SQL in the same way as any other
USERident (i.e. by providing a user name and password). An
OS_USERident is subject to the same access restrictions as any other
PROGRAMidents provide specific privileges required when executing certain operations.
PROGRAMidents 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
A connection should have been established before the
ENTERstatement is used, see Connecting to a Database. Entering a
PROGRAMident is analogous to logging on as a
USERident, in that the
PROGRAMident gains access to the system and any privileges the ident holds become applicable.
PROGRAMidents are generally associated with specific functions within the system, not with physical individuals.
GROUPidents are collective identities that provide common privileges for groups of users or
Any privileges granted to or revoked from a
GROUPident 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.
GROUPidents provide a facility for organizing the privilege structure in the database system.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40