Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is an sql programming .. i want to know the codes .. i do not know how to do it .. how to know
this is an sql programming .. i want to know the codes .. i do not know how to do it ..
how to know what he is asking for ??
(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 aboveStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started