ENTER

Connects a PROGRAM ident to the system.

enter.png

 

Usage

Embedded, Interactive, Module, 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.