Connects a PROGRAM ident to the system.
The specified ident becomes the current ident, provided that the password is correct.
The ident and the password can be specified either as a host variable or as a literal.
A PROGRAM ident is set up to have certain privileges and access to the database which apply after the ENTER statement has been used and replace those that apply to the ident executing the ENTER statement.
The ENTER statement may only be issued for idents of type PROGRAM.
ENTER may not be used to log on to the system.
To perform an ENTER operation for a PROGRAM ident, the current ident must have EXECUTE privilege on that ident.
The ENTER statement may not be issued inside a transaction.
When the ENTER operation is successfully performed, the privileges granted to the new current ident apply and those granted to the previous current ident are suspended until the PROGRAM ident is left, see LEAVE (PROGRAM ident).
ExampleENTER 'MY_PROGRAM' USING 'secret';
For more information, see the Mimer SQL User's Manual, chapter 4, PROGRAM Idents - ENTER and LEAVE.
MIMER EXTENSION Support for the ENTER statement is a Mimer SQL extension.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40