Question: Q.3) (25 points) Granting and Revoking Privileges Write statements that do the following: - Grant privileges to ap_superuser as follows: o SELECT/UPDATE/INSERT/DELETE privileges to all

Q.3) (25 points) Granting and Revoking Privileges

Write statements that do the following:

- Grant privileges to ap_superuser as follows: o SELECT/UPDATE/INSERT/DELETE privileges to all tables in ap database

- Grant privileges to ap_dev as follows: o SELECT/UPDATE/INSERT privileges to all tables in ap database

- Grant privileges to ap_guest as follows: o SELECT privileges to all tables

o UPDATE privileges to VENDORS table only

- Revoke all privileges from ap_guest

- Revoke INSERT privileges from ap_dev

pg. 2

Q.4) (25 points) Viewing User and Privilege Information

Write statements to do the following:

- Display a list of user and host for all users, sort by host, then user.

- Show grants for the currently logged on user

- Show privileges for lazydaisy

- Show privileges for ap_superuser

- Show privileges for ap_guest

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!

Q:

Refer to the diagram for Problem 13 for the expenditure cycle. Required a. List the entity database tables, and describe which entities need representing from an AIS perspective. b. For each item...

Q:

Answer the questions below for the table -- Create the petSupplies table drop table if exists petSupplies; CREATE Table IF NOT EXISTS petSupplies ( prodID VARCHAR(50), suppDescription VARCHAR(2000),...

Q:

Q3 (25 points). For the same problem in Q1, now we want to implement a periodic inventory control policy. The company decides to monitor inventory every month and order accordingly. a) (15 points)...

Q:

Q1. Manolya deposits $20.000 in the bank today. Starting three years from now, she makes equal withdrawals of $1.500 for five years then withdraws the remaining amount ten years from now. How much...

Q:

Q3) (25 points) A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are three origins for this raw material, Which must be...

Q:

Q3) (25 points) A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are three origins for this raw material, which must be...

Q:

OJ (25) LO Implement the puree loading and recorre levelling technique so that yua moth the daily ww. What are the maximum and minimum daily resource we before and after sppbing the Revelling Site) ....

Q:

The question is reposted below for your reference ABC is a small open economy in the world market for watches. The market for watches in ABC is given as follows: (Domestic) Supply: QS= 500 + 4P...

Q:

Q3.) (25 points) Use the ap database for this question. Write a query that selects vendors and any invoice they have to replicate the result set below, matching all data and format aspects, including...

Q:

Q3 (25 points): Consider a decision maker with the utility function, u(x) = 1-e-x/R. Assume that the risk tolerance R for this particular decision maker is $40,000. He considers the following two...

Q:

Q3/ (25 points) In a specific industry of producing iron, the industry produced 2000 kg of iron by utilizing 1800 kg of raw material for the first month. In the second month, this comapany produced...

Q:

On March 1, 2012, Mechanics Credit Union (MCU) issued 7%, 20-year bonds payable with maturity value of $300,000. The bonds pay interest on February 28 and August 31. MCU amortizes bond premium and...

Q:

b) Prepare the Bank Reconciliation on March 31(List items that increase balance as per bank & books first) The bank portion of last month's bank reconciliation for Wildhorse Ltd. at February 28...

Q:

BE9.15 (LO 5) Ottawa Corporation owns machinery that cost $20,000 when purchased on July 1, 2022. Depreciation has been recorded at a rate of $2,400 per year, resulting in a balance in accumulated...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

KEY QUESTION In long-run equilibrium, P minimum ATC MC. Of what significance for economic efficiency is the equality of P and minimum ATC? The equality of P and MC? Distinguish between productive...

Q:

KEY QUESTION Complete the following table by calculating marginal product and average product from the data given: Plot the total, marginal, and average products and explain in detail the...

Q:

KEY QUESTION A firm has fixed costs of $60 and variable costs as indicated in the table on the next page. Complete the table and check your calculations by referring to question 4 at the end of...