FAQ:PB DEFINER MySQL MARIADB

Versions antérieures à la 2025.01

Requête de génération de l'ordre (à adapter au besoin) : SELECT CONCAT("ALTER DEFINER='dbsqware_user'@'localhost' VIEW ", table_name, " AS ", view_definition, ";") FROM information_schema.views WHERE table_schema='dbsqware_db';

Exemple de requête générée ALTER DEFINER='dbsqware_user'@'localhost' VIEW `v_StorageType` AS select `dbsqware_db`.`tsqwora_Datafiles`.`dbalias` AS `dbalias`,sum(case when locate('+',`dbsqware_db`.`tsqwora_Datafiles`.`file_name`) <> 0 then `dbsqware_db`.`tsqwora_Datafiles`.`size_dbf` else 0 end) AS `sizeAsm`,sum(case when locate('/ZDATA/',`dbsqware_db`.`tsqwora_Datafiles`.`file_name`) <> 0 then `dbsqware_db`.`tsqwora_Datafiles`.`size_dbf` else 0 end) AS `sizeZfs`,sum(`dbsqware_db`.`tsqwora_Datafiles`.`size_dbf`) AS `size_dbf`,max(`dbsqware_db`.`tsqwora_Datafiles`.`gather_date`) AS `gather_date` from `tsqwora_Datafiles` group by `dbsqware_db`.`tsqwora_Datafiles`.`dbalias`;