-
Bharathy Satish authored
AND STORED PROGRAMS Problem: Create a view(v1) with definer set to non existing user and then define another view(v2) on top of view v1 without any definer clause. Now when these views are backed up and tried to restore, restore fails when creating v2 stating non existing user does not exists. Analysis: This problem is because user account DDLs are dumped after view definitions are dumped. Fix: Fix is to dump view definitions at the last in the dump file.
Bharathy Satish authoredAND STORED PROGRAMS Problem: Create a view(v1) with definer set to non existing user and then define another view(v2) on top of view v1 without any definer clause. Now when these views are backed up and tried to restore, restore fails when creating v2 stating non existing user does not exists. Analysis: This problem is because user account DDLs are dumped after view definitions are dumped. Fix: Fix is to dump view definitions at the last in the dump file.
Loading