An ident is an authorization-id used to identify users, programs and groups. There are three types of idents in a Mimer SQL database:
USERidents identify individual users who can connect to a Mimer SQL database.
USERidents are generally associated with specific physical individuals who are authorized to use the system.
USER's access to the database objects is restricted by the specific privileges granted to the ident.
USERident is usually protected by a password. For a
USERident it is also possible to add one or several
OS_USERlogins which allows the user currently logged in to the operating system to access the Mimer SQL database without providing a password.
For example: if there is a
ALBERTdefined in Mimer SQL that has an
ALBERT, then the operating system user
ALBERTmay start Mimer BSQL (for example) and connect directly to Mimer SQL simply by pressing <return> at the
However, if the
ALBERTdefined in Mimer SQL has an
HERBERT, then the operating system user
HERBERTmay start Mimer BSQL and connect directly to Mimer SQL by entering
Username:prompt and simply pressing <return> at the
PROGRAMidents can be used for effective administration of access rights and authorization control.
PROGRAMidents do not strictly connect to Mimer SQL, but they may be entered by an ident by using the
ENTERstatement 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
PROGRAMident is set up to have certain privileges and these apply after the
ENTERstatement has been used.
PROGRAMidents are generally associated with specific functions within the system, rather than with physical individuals.
PROGRAMident is entered, any privileges granted to that ident become current and privileges belonging to the previous ident (i.e. the ident issuing the
ENTERstatement) are suspended.
PROGRAMidents are disconnected with the
GROUPidents are collective identities used to define groups of user and/or program idents.
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 a group can include any number of members.
GROUPidents provide a facility for organizing the privilege structure in the database system. All idents are automatically members of the group
PUBLIC. When a privilege is granted to
PUBLIC, all users receive the privilege.
Mimer Information Technology AB
Phone: +46 18 780 92 00