Question : Having written this trigger create: CREATE OR REPLACE TRIGGER PROTECT_DB BEFORE DROP OR TRUNCATE ON X.SCHEMA How can […]
Tag: ddl-trigger
How to Deny permissions for newly created user in DDL Trigger?
Question : I’m having trouble with a SQL DDL trigger for Create_User and I’m wondering if there is an issue […]
Create DDL Trigger Dynamically
Question : I’m trying to create a DDL Trigger dynamically so I can create a job that checks each database […]
Create event trigger as non-superuser in Postgres
Question : Is it possible to give a role or a set of attributes to a non-superuser in postgres that […]
Does the SQL Standard mention trigger events on DDL (ALTER, CREATE, DROP)?
Question : PostgreSQL supports “Event Triggers” which is defined as, To supplement the trigger mechanism discussed in Chapter 39, PostgreSQL […]
How can I resolve a database trigger’s name with built-in functions?
Question : I have a database trigger that I use to prevent me from creating certain procedures in user databases. […]
Error when passing variable to function
Question : I’ve created a function in PostgreSQL 11.10 to handle DDL change in pglogical to apply it into subscriber. […]
lock escalation issue when using DDL trigger
Question : I have a problem, I am trying to create a log table for my database so I can […]
How to trigger a function with DDL query?
Question : I want to add a few sanity checks on my DDL statements. Unfortunately, I cannot run a validation […]
failed logon trigger blocking access into SQL Server instance
Question : I wanted to create a trigger to record all the names of logins(who logon into system) in ServerLogonRecords […]
- 1
- 2