Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


PROGRAM Idents - ENTER and LEAVE


PROGRAM idents may be entered from within an SQL session by using the ENTER statement. The current user must have EXECUTE privilege on the PROGRAM ident in order to perform an ENTER.

When a PROGRAM ident is entered, any privileges granted to that ident become current and privileges belonging to the previous ident (i.e. the ident issuing the ENTER statement) are suspended.

PROGRAM idents are disconnected with the LEAVE statement.

Example:
 ENTER 'PROGRAM_NAME' USING 'secret';
 
 LEAVE RETAIN;
 

The statements ENTER and LEAVE may not be issued within transactions, see Managing Transactions.


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