ENTER

---

Connects a PROGRAM ident to the system.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

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.

Restrictions

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.

Notes

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).

Example

 ENTER 'TSTPRG' USING 'secret';
 

Standard Compliance

Standard	Compliance	Comments
	Mimer SQL extension	Support for the ENTER statement is a Mimer SQL extension.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se