Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX