How would you identify all stored procedures that pose the same problem?

You inherit a legacy database system when the previous DBA, Bob, leaves the company.
You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2,
@count); ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) does
not exist How would you identify all stored procedures that pose the same problem?

You inherit a legacy database system when the previous DBA, Bob, leaves the company.
You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2,
@count); ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) does
not exist How would you identify all stored procedures that pose the same problem?

A.
Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.

B.
Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE
DEFINER=’bob@localhost’;.

C.
Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE
USER=’bob’ and HOST=’ localhost’;.

D.
Examine the Mysql error log for other ERROR 1449 messages.

E.
Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.



Leave a Reply 2

Your email address will not be published. Required fields are marked *