Question : Is it possible to give a role or a set of attributes to a non-superuser in postgres that […]
Tag: ddl-trigger
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 […]
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 […]
DDL Trigger not working as expected SQL Server 2012
Question : I have a DDL Trigger in SQL Server 2012 as: CREATE TRIGGER [AuditProcChanges] ON DATABASE FOR CREATE_TABLE,ALTER_TABLE,DROP_TABLE AS […]
mysql trigger data from a many to many relation
Question : I am new to triggers, so I want to know how I could select attributes from 3 different […]
- 1
- 2