Example 1: Stopping UDT Logging And SQL Text
This example stops logging the SQL text for the failed attempts.
END LOGGING DENIALS WITH TEXT ON UDTTYPE;
Example 2: Stopping UDT Logging On a UDT Type
This example stops logging for all of the following attempts that failed because of insufficient privileges.
- ALTER TYPE
- CREATE CAST
- CREATE ORDERING
- CREATE TRANSFORM
- CREATE TYPE
- DROP CAST
- DROP ORDERING
- DROP TRANSFORM
- DROP TYPE
- REPLACE CAST
- REPLACE ORDERING
- REPLACE TRANSFORM
- method invocation
- NEW specification
- UDT reference
END LOGGING DENIALS ON UDTTYPE;
Example 3: Stopping UDT Logging On a UDT Method
This example stops logging for all of the following request attempts that fail because of insufficient privileges.
- ALTER METHOD
- ALTER TYPE
- CREATE CAST
- CREATE METHOD
- CREATE ORDERING
- CREATE TRANSFORM
- CREATE TYPE
- DROP CAST
- DROP METHOD
- DROP ORDERING
- DROP TRANSFORM
- DROP TYPE
- REPLACE CAST
- REPLACE ORDERING
- REPLACE TRANSFORM
- method invocation
- NEW specification
- UDT reference
END LOGGING ON UDTMETHOD;