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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se