this is an sql programming .. i want to know the codes .. i do not know how to d

Question

this is an sql programming .. i want to know the codes .. i do not know how to do it ..

(2) Next, the script grants to the new user to read data from the relational tables EMPLOYEE and JOBHISTORY, and to create the views located in a database with the same name as a prefix of your University email account. The privileges must be granted such that the new user is able to grant all privileges listed above to the other users (3) Next, the script sets the following values of resource limits to a name of account owner is the same as a prefix of your University email account: total number of queries an account owner can issue per hour must be set to 100, and total number of simultaneous connections to the server by an account owner must be set to 3, total number of times an account can connect to the server per hour must be 10 (4) Next, the script locks an account of the new user with the same name as the prefix of your University email account. (5) Finally, the script lists the privileges granted to the new user, the values of resource limits set in a step (3) and a status of the account a prefix of your University email account set in a step (4). To do so your script must access appropriate relational tables in a database mysql. Do not list information not related to the actions performed above

Explanation / Answer

Hi,

This kind of questions of SQL are the queries which needs to be triggered as from the questions

as from Question 1. New user .

This mean the moment a user is added in the database we need to run the sql . So this is a Stored procedure , Execute SQL query on some event

1. You need yo understand how to write a stored procedure for what ever databse it is.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.