distal-attribute
distal-attribute
distal-attribute
distal-attribute

show triggers

BubikolRamios posted 4 years ago in General
show triggers;
/* 0 rows affected, 0 rows found. Duration for 1 query: 0,030 sec. */

False, triggers are there, just don't have (don't know which) privileges to see them. Also triggers are not shown in HSQL tree window, no warnings/errors.

Regards
BubikolRamios posted 4 years ago
If any comfort (-:, mysql query browser does the same.
ansgar posted 4 years ago
If you have no privs to see them what do you expect from Heidi in that case?
BubikolRamios posted 4 years ago
Tell me that I have no privs and which is that I need. I mean I do get that kind of info from time to time from different apps. mybe even form HSQL, can tell out from head now.

As it is now, I could panic that all my triggers are gone.
ansgar posted 4 years ago
Think you need the SUPER privilege on 5.1 servers and below, and on newer servers you need the TRIGGER priv. But I can be wrong.

Please login to leave a reply, or register at first.