An ident is an authorization-id used to identify users, programs and groups. The different types of idents in a Mimer SQL database are
USERidents identify individual users who can connect to a Mimer SQL database.
USERident's access to the database is usually protected by a password, and is also restricted by the specific privileges granted to the ident.
USERidents are generally associated with specific physical individuals who are authorized to use the system.
USERident it is 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 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_USERlogin no ident name needs to be given, it is sufficient to press <return> at the username: prompt.
USERident may be defined without a password and in that case it is only possible to connect to Mimer SQL by using the
OS_USERlogin. Dropping and adding password and
OS_USERlogins is done with
PROGRAMidents do not strictly connect to Mimer SQL, but they may be entered from within an application program 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.
LEAVEstatement is used to return to the state of privileges and database access that existed before
GROUPidents are collective identities used to define groups of
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 a logical group which is specified in Mimer SQL statements by using the keyword
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40