Richard Martin wrote : > >Hi, > >After migrating the DB to 7.5.0.14, I cannot see/select the existing >triggers (SELECT triggername, definition FROM DOMAIN.TRIGGERS ==> No >Result). I also cannot create new triggers. (Syntax error or access >violation;-5001 POS(1) Missing privilege:NO TRIGGERS FOR >REPLICATION USER). >But the (now "invisible") triggers I migrated with (as >everything else in >the DB) work very well. > >So, i got problem with privileges(?) which I do not >understand, because I >did not change any user/usergroups/owner and before the migration every >trigger was shown. >Who is this REPLICATION USER - did I do things wrong with the >migration-backup/restore? > >Sorry if this question might be too trival but I could not >find any hint. > >Ciao, >Richard > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] >
With 7.5 the new user property 'replication user' has been introduced for replication support. This requires a new flag in the catalog which tells whether a user is a replication user. This flag must be set by a migration, which automatically starts at the first restart with 7.5. In seems that this migration didn't happen in your database. For further analysis please tell me the the version of your last 7.4 installation. However, I fear there is no workaround for the problem and you will have to wait until a patch is available. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
