An ident in a Mimer SQL system is an authorized user of the system, or the collective identity of a group of users sharing common privileges.
There are three types of idents:
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 user ident 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_USERlogin can be added to a user which allows the user currently logged in to the operating system to connect to a Mimer SQL database without providing a password. (If the Mimer USER ident name is the same as the operating system user name, its possible to connect to Mimer SQL without providing user name.)
OS_USERlogin is defined with a password in Mimer SQL, the ident may connect to Mimer SQL in the same way as any other user ident (i.e. by providing user name and password).
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 to the database should have been established before the
ENTERstatement is used. The ident using the
ENTERstatement must hold
EXECUTEprivilege on the
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 for 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 one group can include any number of members.
GROUPidents provide a facility for organizing the privilege structure in the database system. For examples showing the use of a
GROUPident, see the Mimer SQL User's Manual.
Idents - Access and Authority
PROGRAMidents are authorized users of the system.
PROGRAMident has a unique ident name and a private password which must be correctly supplied to the
ENTERstatement in application programs.
USERident has a unique ident name and an optional private password which must be correctly supplied to the
CONNECTstatement in application programs. Alternatively a
OS_USERlogin may access the database without explicitly providing a password on condition that the username for the user currently logged in to the operating system correspond to the definition of an
OS_USERin the Mimer SQL database.
When Mimer SQL is installed, the user ident
SYSADM, used for database administration, is automatically created. The password for
SYSADMis defined when the system is installed, see SDBGEN - Generating the System Databanks.
All idents in the system belong to a group which is specified by using the keyword
PUBLICin Mimer SQL statements. Privileges granted to
PUBLICare global to the system.
Mimer Information Technology AB
Phone: +46 18 780 92 00