Question: Create a VIEW called customers_private_info that contains three columns: customer_id email_address password Create a trigger called customers_password_length_check that verifies the length of the password

Create a VIEW called customers_private_info that contains three columns: customer_id email_address password Create a trigger called customers_password_length_check that verifies the length of the password hash is exactly 40 characters before an update occurs. Be sure to explain in the error that the password hash length must be 40. Provide an UPDATE statement that attempts to update a row in the customers_private_info VIEW to a password of non 40 length to trigger the error message.
Step by Step Solution
There are 3 Steps involved in it
Heres how you can create the view customersprivateinfo and the trigger customerspa... View full answer
Get step-by-step solutions from verified subject matter experts
