FirebirdSQL logo
 SQL SecuritySupplementary Information 

Management statement are a class of SQL statements for administering aspects of the client/server environment, usually for the current session.Typically, such statements start with the verb SET.

Note

The isql tool also has a collection of SET commands.Those commands are not part of Firebird’s SQL lexicon.For information on isqls SET commands, seeIsql Set Commandsin Firebird Interactive SQL Utility.

Management statements can run anywhere DSQL can run, but typically, the developer will want to run a management statement in a database trigger.A subset of management statement can be used directly in PSQL modules without the need to wrap them in an EXECUTE STATEMENT block.For more details of the current set, see Management Statements in PSQL in the PSQL chapter.

Most of the management statements affect the current connection (attachment, or “session”) only, and do not require any authorization over and above the login privileges of the current user without elevated privileges.

Some management statements operate beyond the scope of the current session.Examples are the ALTER DATABASE {BEGIN | END} BACKUP statements to control the “copy-safe” mode, or the ALTER EXTERNAL CONNECTIONS POOL statements to manage connection pooling.A set of system privileges, analogous with SQL privileges granted for database objects, is provided to enable the required authority to run a specific management statement in this category.

Note

Some statements of this class use the verb ALTER, although management statements should not be confused with DDL ALTER statements that modify database objects like tables, views, procedures, roles, et al.

Although some ALTER DATABASE clauses (e.g. BEGIN BACKUP) can be considered as management statements, they are documented in the DDL chapter.

Unless explicitly mentioned otherwise in an “Available in” section, management statements are available in DSQL and PSQL.Availability in ESQL is not tracked by this Language Reference.

Data Type Behaviour