Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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';
 

For more information, see the Mimer SQL User's Manual, PROGRAM Idents - ENTER and LEAVE.

Standard Compliance

Standard
Compliance
Comments

Mimer SQL extension
Support for the ENTER statement is a Mimer SQL extension.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX