Mimer SQL Idents
An ident is an authorization-ID used to identify different kinds of users in a Mimer SQL database.
There are three 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).
USERident has a unique ident name and an optional private password which must be correctly supplied to the
ENTERstatement in application programs. A
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
USERin the Mimer SQL database.
PROGRAMident has a unique ident name and a private password which must be correctly supplied to the
ENTERstatement in application programs.
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, or by using an
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.
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
Phone: +46 18 780 92 00