The following table is an alphabetical listing of operations that have limitations when specified in a BEGIN LOGGING statement.
Operations to Log | Limitations |
---|---|
ALL | Does not log the following operations, which refer to system level objects that do not support an ON clause:
|
|
The ON clause can only specify a database or user. |
DROP TABLE | The logging also includes ALTER TABLE, which requires the DROP table privilege. |
DROP MACRO or DROP VIEW | Also includes logging of REPLACE for the specified object. |
DROP, EXECUTE or GRANT | The only operations allowed if the ON clause specifies a macro or procedure. |
DUMP, RESTORE or CHECKPOINT | Are not allowed if the ON clause specifies a VIEW. |
The single keyword representation of multiple SQL privileges, for example:
|
Logs all the privileges covered by the keyword. For example, specifying TABLE as the logging operation logs CREATE TABLE, ALTER TABLE, and DROP TABLE. For more information, see Granting Multiple Privileges with a Single Keyword. |
CREATE FUNCTION, DROP FUNCTION, EXECUTE FUNCTION, ALTER FUNCTION, or GRANT | The only operations that can be specified if the ON clause specifies a FUNCTION (internal or external functions). |
UDTUSAGE | The ON clause must specify one of the following:
|
ALTER EXTERNAL PROCEDURE, EXECUTE PROCEDURE, and GRANT | The only operations allowed on external procedures. |