Question: Write a script that creates a user named ray@localhost with a password of temp that the user must change every 9 0 days. This user

Write a script that creates a user named ray@localhost with a password of temp that the user must change every 90 days. This user should have SELECT, INSERT, and UPDATE privileges for the Vendors table of the AP database; SELECT, INSERT, and UPDATE privileges for the Invoices table; and SELECT and INSERT privileges for the Invoice_Line_Items table. This user should also have the right to grant privileges to other users. Run the script in MySQL Workbench

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!